Question: table [ [ Customer , Order ] , [ CustomeriD , FirstName,LastName,Email,City,Onderib,Customento,Orderbate,totalPrice ] , [ 1 , Avined,N , ahned.aliaemal com,Ramallah, 1 , 1
tableCustomerOrderCustomeriDFirstName,LastName,Email,City,Onderib,Customento,Orderbate,totalPriceAvined,Nahned.aliaemal com,Ramallah,Fatima,Whan,tatima khangemall com,Bethlehem,Omx,Abdullah,omar abdulah Eemail com,Joricho,Laytin,Ahenad,layla ahmade emal.com,Nablus,Nada,Hassan,nada hasas femailcom,Hebron,Whated,Amin,Khalid amin Bremail com,Gaza,,,,Hars,Sadiq,hare sadiq e emall com,Jenin,,,,Karim,Rahman,karim rahman teemal oom,Tulkarm,,,,eAishe,Hamid,aisha hamidelemal com,Bethlehem,,,Yountert,Fawal,yousset fawei femalicom,Ramallah,,,,
tableOrderLineOrderDetailio OrderiD,ProductiD,Quantity,Price,
Given the data above write SQL queries to answer the following questions:
Print the ids of orders which contain at least one product of category fruit.
Print ids of orders which contain items of two different categories.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
