Take a look at these member, booking, make tables. Table 1: Member Last Name Gender Age Female 25 Male 36 Female 25 Female 25 Female 36 Male 37 Male 26 United States Female 37 United States Male 24 Male 23 Member ID 1582 2587 3549 9536 2567 2154 3265 8765 3259 6540 3 4 Booking ID 1 2 5 6 First Name Mara Philip Kathleen 7 8 Sau Shanice Chase Tommie Dorcas Angel Weston Room Hashimoto Gent Hanner Pfau Mccrystal Karner Jia Room 15 Room 25 Room 1 Room 15 Room 5 Room 21 Room 3 Room 8 Darity Sanor Martina Date 29-Dec-2020 Table 2: Booking Days 2 4 6 5 10 6 5 4 Table 3: Make MemberID 3549 Country Uganda France United States United States China Australia France China Cost per day $200.00 $80.00 $80.00 $150.00 $150.00 $80.00 $120.00 $300.00 Booking ID Joined Date 16-Aug-2020 21-May-2015 12-Dec-2017 16-Aug-2019 16-Aug-2020 1-Jan-2021 29-Dec-2018 21-May-2019 4-Mar-2019 1-Feb-2022 Status Paid Paid Pending Paid Pending Paid Pending Pending
SQL
SQL stands for Structured Query Language, is a form of communication that uses queries structured in a specific format to store, manage & retrieve data from a relational database.
Queries
A query is a type of computer programming language that is used to retrieve data from a database. Databases are useful in a variety of ways. They enable the retrieval of records or parts of records, as well as the performance of various calculations prior to displaying the results. A search query is one type of query that many people perform several times per day. A search query is executed every time you use a search engine to find something. When you press the Enter key, the keywords are sent to the search engine, where they are processed by an algorithm that retrieves related results from the search index. Your query's results are displayed on a search engine results page, or SER.
i need c
i
ii
iii
Step by step
Solved in 4 steps with 5 images