Question

Can someone please help,

For this lab you will be using SQL SELECT statements (and depending on your structure, JOINs) to query your database tables. You will be turning in the results of the following queries:

1. List all Guests in the databases

2. List all Guests who stayed at least one time between January 3rd, 2019 and March 4th, 2019.

3. List all Inventory items and their current quantities and units when the quantity is less than 3

4. List the volunteers and what shift they worked most recently

5. List all donors in alphabetical order

6. List all donors who live in Atlanta and have donated at least $500 dollars.

7. List all donors who live in either Watkinsville or Athens who have made at least two donations.

If you don't have enough data in your created tables that will allow you to create these queries - add appropriate data to your tables before doing the queries.

Turn in the following:
*A text file containing the SQL commands you used for each question (labelled/comment for each question they satisfy).
*Screenshots for each question's results

Answer 1

1: select * from guest; // This query is used to select all data from guests database. Select statement is used to select data from database and * is used to select all data from guest database.

Result:

2: select * from guest where name Between date="2019-1-3" AND date ="2019-3-4"; // This query is used to select those name whose stay between January 3rd, 2019 and March 4th, 2019.

Result:

3: select Inven_items,quantity,unit where quantity <3; // This query is used to select those Inventory items, quantity and unit whose quantity is less than 3.

Result:

5: select * from donor where order by name asc; // In this query, the data order into ascending order.

Result:

6: select * from donor where Live="Atlanta" AND donate=500; // This query is used to select those whose live in atlanta and also donated at least 500 dollars.

Result: