select * from locations where type = 'Attraction' and not (subtype = 'roller coaster' or subtype = 'Live show' or subtype = 'Movie' or subtype = '4D movie') and status = 'Open' and numvotes > 90 order by avgvote desc
select * from locations where type = 'Attraction' and subtype = 'roller coaster' and status = 'Open' and numvotes >= 50 order by avgvote desc
select * from locations where subtype = 'Live show' and status = 'Open' and numvotes >= 40 order by avgvote desc
select * from locations where (subtype = 'Animatronic show' or subtype = 'Movie' or subtype = '4D movie') and status = 'Open' and numvotes >= 20 order by avgvote desc
SELECT status, DatePart(yyyy, pubdate) as blogyear, DatePart(mm, pubdate) as blogmonth from stories where status = 'live' GROUP BY status, DatePart(yyyy, pubdate), DatePart(mm, pubdate) ORDER BY DatePart(yyyy, pubdate) DESC, DatePart(mm, pubdate) ASC
