Write a query that displays the name and price of all drinks with name that includes the string "Matcha".

2. Write a query that displays the name and price of all drinks supplied by vendor with the name "Tazo".

3. Write a query that displays the total quantity of drinks ordered.

4. Write a query that for each vendor name, displays the number of drinks supplied by that vendor.

5. Write a query that for each order (identified by TID) displays the TID and the total cost of that order.

 

VID VName DRINK DID B1 B2 B3 B4 B5 B6 87 VENDOR VID V1 V2 V3 ORDER TID 111 222 333 INCLUDES TID 111 111 222 333 333 VENDOR DName ZenMaster LillyMintChai AwakeBrew Matcha RoseMatcha RoastPal MatchaRoyale VName Tazo StarCoffee GreenStar Name Zarko Todd Nia DID 538853 B4 BS B7 VID V1 SSSSSSS V3 V2 V3 V1 V2 V3 DID DName 2 Price VID K TIO Name Type Type App Register App Quantity 2 1 1 2 DRINK ORDER Price 4 3 57777 6 3 INCLUDES DID PA TID Quantity