Write and execute a variety of queries – Database Management System
Create the following queries based on the information you populated in your database. Make sure to include, at a minimum, the following statements:
1. Select, From, Where (PG 261)
2. Count (PG 265)
3. Group By (PG 275)
4. AVG (PG 265)
5. Boolean Operator (And, Or, Not) (PG 268)
You create and run these statements in SQL to insure that each works appropriately. You will submit the Query question and the result in the Word document. You may print screen the result of the query.
Please make sure to use the standard format for writing the queries.
a) Complete populating at least four separate tables in the database with sample data. There needs to be a minimum of 5 – 6 records for each table.
b) Write and execute a variety of queries, based on the introduction to SQL in this to test the functionality of the database. Provide a document listing the SQL query statement and a screenshot of the results. Submit a minimum of 8 queries and the results.
