In this labwork, you are required to write queries for your tables. You willanalyze the entries in your table with the help of queries like following:• Inner join show reservations and details:Inner join with condition that price > 200:• Show number of each soup kind in your tablesShow reservations that desserts’ name ends with letter ‘ç’ or ‘c’• Find maximum price among your reservations.• Sum all the tips in your table and display.• Display average tip paid for each customer.• Update the price and tip values according to condition Main Food= ‘İskender’• Delete reservations which are before the 22/04/2021 .• Insert at least one entity into your tables. IdResID SoupMainSaladDessert Tip DateCustomerID11012 1002MantarSpaghetti CheffSütlaç23 24.04.2021 10021014 1001Mercimek İskender Mevsim Sütlaç25 25.04.2021 10131017 103MantarAdanaCheffGüllaç26 26.03.2021 101• Find maximum price among your reservations.• Sum all the tips in your table and display.Display average tip paid for each customer.100 %100 %O ResultsO ResultsTotal TipsMessagesMessagesMaximum Price12551109100 %ResultsMessagesCustomerlD Average Tip11001910123 Results ei MessagesIduserld resDateprice IdResID SoupMainSaladDessert Tip DateCustomerID1| 1000 10017.04.2021 175 1000 1000 Tarhana İskender Çoban Künefe 15 21.04.2021 1001001 10121.04.2021 200 1006 1001 Mercimek BeytiMevsim Baklava 20 22.04.2021 10131002 10016.04.2021 265 1012 1002 MantarSpaghetti CheffSütlaç 23 24.04.2021 10041001 10121.04.2021 200 1014 1001 Mercimek İskender Mevsim Sütlaç 25 25.04.2021 101Inner join with condition that price > 200:O Results i Messagesuserld resDate1002 100Idprice IdResID SoupMainSaladDessert Tip DateCustomerID16.04.2021 265 1012 1002 Mantar Spaghetti Cheff Sütlaç123 24.04.2021 100Show number of each soup kind in your tablesResultsMessagesSoupComparison of Soups1Mantar12Mercimek23Tarhana1MainComparison of Mains1Вeyti12İskender23Spaghetti1DessertComparison of Desserts1Baklava12Künefe13Sütlaç22.

Queries of inner join combine two tables upon a common attribute.

Answered: • Inner join show reservations and…

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

In this labwork, you are required to write queries for your tables. You will
analyze the entries in your table with the help of queries like following:
• Inner join show reservations and details:

Inner join with condition that price > 200:

• Show number of each soup kind in your tables

Show reservations that desserts’ name ends with letter ‘ç’ or ‘c’

• Find maximum price among your reservations.
• Sum all the tips in your table and display.
• Display average tip paid for each customer.

• Update the price and tip values according to condition Main Food= ‘İskender’
• Delete reservations which are before the 22/04/2021 .
• Insert at least one entity into your tables.