The wonderful writing ability for all Microsoft employees
Budget: $250 – $750 USD
SQL queries
Simply I want you to write me 4 queries based on a database I will attach it.
The Rules are..
The student can write error-free SQL queries.
All SQL queries run without errors and produce the intended results.
The student can use JOINs correctly in SQL queries.
Each SQL query needs to include one or more explicit JOINs. The JOIN or JOINs should be necessary to the query.
If a question does not require a JOIN please change the question to be one that does.
The student can use aggregations correctly in SQL queries.
Each SQL query needs to include one or more aggregations. This could be a COUNT, AVG, SUM, or other aggregation.
The student can use subqueries and Common Table Expressions.
At least 2 of the 4 SQL queries need to include either a subquery OR a CTE.
The student can use Window Functions.
At least 1 of the 4 queries should use a Window Function.
The SQL queries are well formatted.
The SQL queries are well formatted and use aliases.
Simply I want you to write me 4 queries based on a database I will attach it.
The Rules are..
The student can write error-free SQL queries.
All SQL queries run without errors and produce the intended results.
The student can use JOINs correctly in SQL queries.
Each SQL query needs to include one or more explicit JOINs. The JOIN or JOINs should be necessary to the query.
If a question does not require a JOIN please change the question to be one that does.
The student can use aggregations correctly in SQL queries.
Each SQL query needs to include one or more aggregations. This could be a COUNT, AVG, SUM, or other aggregation.
The student can use subqueries and Common Table Expressions.
At least 2 of the 4 SQL queries need to include either a subquery OR a CTE.
The student can use Window Functions.
At least 1 of the 4 queries should use a Window Function.
The SQL queries are well formatted.
The SQL queries are well formatted and use aliases.