You may choose any DB schema of your choice. In your report, provide the schema design and after that, you must provide
Posted: Sun Jul 03, 2022 10:00 am
You may choose any DB schema of your choice. In your report,provide the schema design and after that, you must provide 10different examples of queries and the SQL commands to answer suchqueries? Queries should include the following:
1. SQL with a selection condition
2. SQL with Join condition
3. SQL with Like operator
4. SQL with set operations either UNION, INTERSECT, orEXCEPT
5. SQL command with a mathematical operation
6. SQL with “Is NULL” or “Is Not NULL”
7. SQL with an Order by
8. SQL with a Group by
9. SQL with aggregation functions
10. SQL with Having clause
(PLEASE DO NOT COPY PASTE ANY PREVIOUS ANSWER)
1. SQL with a selection condition
2. SQL with Join condition
3. SQL with Like operator
4. SQL with set operations either UNION, INTERSECT, orEXCEPT
5. SQL command with a mathematical operation
6. SQL with “Is NULL” or “Is Not NULL”
7. SQL with an Order by
8. SQL with a Group by
9. SQL with aggregation functions
10. SQL with Having clause
(PLEASE DO NOT COPY PASTE ANY PREVIOUS ANSWER)