human
Schema:
shop (Shop_ID, Address, Num_of_staff, Score, Open_Year)
member (Member_ID, Name, Membership_card, Age, Time_of_purchase, Level_of_membership, Address)
happy_hour (HH_ID, Shop_ID, Month, Num_of_shaff_in_charge)
happy_hour_member (HH_ID, Member_ID, Total_amount)
Please answer with SQL.
assistant
Sure, I understand.
human
how many membership cards? | There are 2 different membership cards. | what is age of Ashby Lazale
assistant
SELECT age FROM member WHERE name = 'Ashby, Lazale';
human
how many time of purchase in ashby lazale
assistant
SELECT Time_of_purchase FROM member WHERE name = 'Ashby, Lazale';
human
Level of membership Breton, Robert
assistant
SELECT Level_of_membership FROM member WHERE name = "Breton, Robert" ;