r/askIT • • Aug 26 '21

SQL & QUERIES

i need help to get answers for below quiestions,

SQL & QUERIES:

Devise 6 SQL queries that demonstrate appropriate use of the following:

  1. Use of the between logical operator;

  2. AN example of DISTINCT within your query

  3. TO_CHAR function;

  4. An aggregate function in the SELECT list

  5. A GROUP BY command

  6. A SUBQUERY;

At least one of the above queries should include data from more than one table and a different query should demonstrate the use of an OUTER JOIN.

Include the following for each query:

- Short sentence saying what the query is doing

- SQL Query

- Result

0 Upvotes

2 comments sorted by

1

u/marku01 Aug 26 '21

No one here is doing your homework. You can look at Cheatsheets and make sure you use a correct one. SQL can be a bit different depending on what server you are querying

1

u/lamerlink Aug 26 '21

Honestly, most of these are question are very easy beginner questions behave they’re asking for literally any query you can write with the one requirement.

Take the time to Google each function/keyword and just write something yourself. You’ll only be helping yourself in the long run.