Write the SQL statements that provide the following database functionality: Query 1. Write an SQL statement that
Question:
- Write the SQL statements that provide the following database functionality:
Query 1. Write an SQL statement that correctly uses the 'LIKE' symbol on an alphanumeric field to select a subset of data. Explain the purpose of your query for your database solution.
Query 2. Write an SQL statement that correctly implements a JOIN statement over two or more entities to select a subset of data. Explain the purpose of your query for your database solution.
Query 3. Write an SQL statement that correctly uses the '>' operator to select a subset of data for a single entity. Explain the purpose of your query for your database solution.
Query 4. Write an SQL statement that correctly uses the 'GROUP BY' operator to select an aggregation of data (e.g. SUM, AVG, COUNT). Explain the purpose of your query for your database solution.
Query 5. Write an SQL statement that correctly uses the 'IN' symbol to select a subset of data for a single entity. Explain the purpose of your query for your database solution.
Query 6.Write an SQL statement that correctly uses the 'UPDATE' symbol tomodify at least three rows of data in one of your tables. Explain the purpose of your query for your database solution.
Modern Database Management
ISBN: 978-0133544619
12th edition
Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi