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
Show the information about the shops that are not 'Apple'.
assistant
SELECT * FROM shop WHERE Shop_Name != 'Apple';
human
How about the shops are 'Apple'?
assistant
SELECT * FROM shop WHERE Shop_Name = 'Apple';
human
What are the open dates and open years of them?
assistant
SELECT Open_Date , Open_Year FROM shop WHERE Shop_Name = "Apple" ;