Dec-09-2018, 12:59 PM
I couldn't write 4 SQL SELECT statements satisfying the following conditions:
At least one of the queries should incorporate a single or multiple "WITH" (CTE) statements(s)
At least one of the queries should incorporate a subquery
At least one of the queries should have a GROUP BY and HAVING caluses
At least two of the queries should incorporate JOINS (LEFT, RIGHT, INNER, FULL) of two or more tables
All queries should have at least two logical conditions in WHERE clauses (note that the logical conditions can be in any part of the statement - WITH queries, subqueries, etc - and can be in separate parts - e.g. one in WITH query, the other in the main query)
All queries should have at least one ordering field with an ORDER BY clause in the main statement
Each query should return at most 100 records (you can use LIMIT for that)
The purpose or rationale of the query (what the query is meant to do) should be provided clearly in English before each query
The output of each query should be provided along
I can provide more than 4 queries (however, not more than 6) if ı cannot satisfy the above conditions with 4 queries
I have to submit one simple text file that includes:
- intention of the query
- the query itself
- the output of the query
please help me thank you for helping
At least one of the queries should incorporate a single or multiple "WITH" (CTE) statements(s)
At least one of the queries should incorporate a subquery
At least one of the queries should have a GROUP BY and HAVING caluses
At least two of the queries should incorporate JOINS (LEFT, RIGHT, INNER, FULL) of two or more tables
All queries should have at least two logical conditions in WHERE clauses (note that the logical conditions can be in any part of the statement - WITH queries, subqueries, etc - and can be in separate parts - e.g. one in WITH query, the other in the main query)
All queries should have at least one ordering field with an ORDER BY clause in the main statement
Each query should return at most 100 records (you can use LIMIT for that)
The purpose or rationale of the query (what the query is meant to do) should be provided clearly in English before each query
The output of each query should be provided along
I can provide more than 4 queries (however, not more than 6) if ı cannot satisfy the above conditions with 4 queries
I have to submit one simple text file that includes:
- intention of the query
- the query itself
- the output of the query
please help me thank you for helping