Python Forum
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
SQL statements
#1
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 Heart Angel
Reply
#2
We're happy to help you with your work, but we're not going to do it for you. Show us what you've tried and tell us why that isn't adequate.
Craig "Ichabod" O'Brien - xenomind.com
I wish you happiness.
Recommended Tutorials: BBCode, functions, classes, text adventures
Reply
#3
Besides that, this is a Python forum so asking SQLs questions might be odd.
Reply


Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020