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

I need answer as soon as possible please. task is

I need answer as soon as possible please. task is

I need answer as soon as possible please. task is

I need answer as soon as possible please. task is

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!