Question: I need answer as soon as possible please. task is related to SQL. I'm waiting for your response. thank you so much in advance. Assignment





I need answer as soon as possible please. task is related to SQL. I'm waiting for your response. thank you so much in advance.
Assignment #2: SQL 1 Goal Learn about and use various SQL constructs. Two files must be submitted: - report (DBMS_2_Surname.docx) - database (DBMS_2_Surname.accdb) 2 Task 1. Create the following types of SQL queries: 1) query with one table and multiple conditions in WHERE clause; 2) query with two related tables and multiple conditions in WHERE clause; 3) query with grouping GROUP BY; 4) query with two related tables and query with grouping GROUP BY; 5) query with grouping and HAVING clause (conditions for groups); 6) query with two related tables, grouping and HAVING clause (conditions for groups); 7) query with subquery in SELECT clause; 8) query with subquery in FROM clause; 9) query with subquery in WHERE clause; 10) query with UNION construction; 11) query with EXISTS construction; 12) at least 3 queries with INNER JOIN; 13) at least 3 queries with LEFT JOIN; 14) at least 3 queries with RIGHT JOIN; In queries include: - LIKE together with "?", &; - ANY; ALL; IN; BETWEEN; DISTINCT. - TOP In queries include aggregation functions COUNT(), SUMO), MAX(), AVGO). In queries include text and datetime functions; In queries include expressions (e.g. addition and subtraction). 2. Conclusions 3 Database description > 4 SQL queries 4.1 Query#1 name Query goal Query SQL code Result of execution Analysis of results, what in these data can be seen>> 4.2 Query#2 name Query goal Query SQL code Result of execution Analysis of results, what in these data can be seen>> 4.3 Query#3 name Query goal Query SQL code Result of execution Analysis of results, what in these data can be seen>> 4.4 Query#4 name Query goal Query SQL code Result of execution Analysis of results, what in these data can be seen>> 4.5 Query#5 name Query goal Query SQL code Result of execution Analysis of results, what in these data can be seen>> 4.6 Query#6 name Query goal Query SQL code Result of execution Analysis of results, what in these data can be seen>> 5 Conclusions Criteria Count of Number of queries queries (see NN) 4.1, 4.2, 4.4 or more 4.2 4.3 Query with 2 conditions From with 2 or more tables Use of Group by From with 2 or more tables and Group by Use of Having From with 2 or more tables and Tlaving Ordering of data query with subquery in SELECT clause; query with subquery in FROM clause; query with subquery in WHERE clause; query with UNION construction; query with EXISTS construction; at least 3 queries with INNER JOIN; at least 3 queries with LEFT JOIN; at least 3 queries with RIGHT JOIN; Use of aggregation functions Use of text functions 4.5 4.1 Use of datetime functions 4.2 Use of predicates Use of expressions (e.g. addition and subtraction)Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
