Problem Find order details made by Jill and Eva. Consider the Jill and Eva as first names of customers. Output the order date, details and cost along with the first name. Order records based on the customer id in ascending order. Tables: customers +--------------+---------+ | id…

Problem Write a query that calculates the difference between the highest salaries found in the marketing and engineering departments. Output just the absolute difference in salaries. Tables: db_employee, db_dept db_employee +--------------+---------+ | id | int | +--------------+---------+ | first_name…

1179. Reformat Department Table Problem Write an SQL query to reformat the table such that there is a department id column and a revenue column for each month. The query result format is in the following example: Department table: +------+---------+-------+ | id | revenue | month | +------+---------+-------+ | 1…

178. Rank Scores Problem Table: Scores +-------------+---------+ | Column Name | Type | +-------------+---------+ | Id | int | | Score | decimal | +-------------+---------+ Id is the primary key for this table. Each row of this table contains the score of a game. …

627. Swap Salary Problem Write an SQL query to swap all 'f' and 'm' values (i.e., change all 'f' values to 'm' and vice versa) with a single update statement and no intermediate temp table(s). Note that you must write a single update statement, DO NOT write any select statement for…

196. Delete Duplicate Emails Problem Write an SQL query to delete all the duplicate emails, keeping only one unique email with the smallest Id. Return the result table in any order. The query result format is in the following example. Example 1: Input: Person table: +----+------------------+ | Id | Email…

177. Nth Highest Salary Problem Table: Employee +-------------+------+ | Column Name | Type | +-------------+------+ | Id | int | | Salary | int | +-------------+------+ Id is the primary key column for this table. Each row of this table contains information about the salary of an employee. Write an SQL…

197. Rising Temperature Problem Write an SQL query to find all dates’ Id with higher temperatures compared to its previous dates (yesterday). Return the result table in any order. The query result format is in the following example. Example 1: Input: Weather table: +----+------------+-------------+ | Id | RecordDate | Temperature | +----+------------+-------------+ | 1…

596. Classes More Than 5 Students Problem There is a table courses with columns: student and class Please list out all classes which have more than or equal to 5 students. For example, the table: +---------+------------+ | student | class | +---------+------------+ | A | Math…