Hi, im new here. i want to ask about queries using mysql that i cant accomplished. there are 3 tables in the screenshot (sorry for bad quality cause i just can upload 1 image).
- user : sellid, buyid, register, negara
- impress : sellid, total_clicks, impressions, total_views
- order : sellid, orderid, buyid, itemid, gmv, time
the questions :
1.search number of customer (buyid) of each country(negara) that purchased item with even and odd itemid (integer) number
2. search number of order/views and clicks/impressions of each sellid