Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select
- count(date_format(start_date, '%W')) AS "NUMBER OF DAYS",
- repeat('*', "NUMBER OF DAYS")
- from ABC
- select
- `NUMBER OF DAYS`,
- repeat('*', `NUMBER OF DAYS`)
- from
- (
- select
- count(date_format(start_date, '%W')) AS `NUMBER OF DAYS`
- from ABC
- ) as t
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement