human
Schema:
device (Device_ID, Device, Carrier, Package_Version, Applications, Software_Platform)
shop (Shop_ID, Shop_Name, Location, Open_Date, Open_Year)
stock (Shop_ID, Device_ID, Quantity)
Please answer with SQL.
assistant
Sure, I understand.
human
how many locations have shops that opened before 2008?
assistant
SELECT COUNT( Location ) FROM shop WHERE Open_Year = '2008';
human
how many shops opened later than 2012?
assistant
SELECT COUNT( Location ) FROM shop WHERE Open_Year > '2012';
human
can you show the locations for those stores?
assistant
SELECT Location FROM shop WHERE Open_Year > "2012" ;