Skip to content

Latest commit

 

History

History

easy

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
1050. Actors and Directors Who Cooperated At Least Three Times.sql
1050. Actors and Directors Who Cooperated At Least Three Times.sql
 
 
1068. Product Sales Analysis I.sql
1068. Product Sales Analysis I.sql
 
 
1069. Product Sales Analysis II.sql
1069. Product Sales Analysis II.sql
 
 
1075. Project Employees I.sql
1075. Project Employees I.sql
 
 
1076. Project Employees II.sql
1076. Project Employees II.sql
 
 
1082. Sales Analysis I.sql
1082. Sales Analysis I.sql
 
 
1083. Sales Analysis II.sql
1083. Sales Analysis II.sql
 
 
1084. Sales Analysis III.sql
1084. Sales Analysis III.sql
 
 
1113.Reported Posts.sql
1113.Reported Posts.sql
 
 
1141. User Activity for the Past 30 Days I.sql
1141. User Activity for the Past 30 Days I.sql
 
 
1142. User Activity for the Past 30 Days II.sql
1142. User Activity for the Past 30 Days II.sql
 
 
1148. Article Views I.sql
1148. Article Views I.sql
 
 
1173. Immediate Food Delivery I.sql
1173. Immediate Food Delivery I.sql
 
 
1179. Reformat Department Table.sql
1179. Reformat Department Table.sql
 
 
1211. Queries Quality and Percentage.sql
1211. Queries Quality and Percentage.sql
 
 
1241. Number of Comments per Post (Easy).sql
1241. Number of Comments per Post (Easy).sql
 
 
1251. Average Selling Price (Easy).sql
1251. Average Selling Price (Easy).sql
 
 
1280. Students and Examinations (Easy).sql
1280. Students and Examinations (Easy).sql
 
 
1294. Weather Type in Each Country (Easy).sql
1294. Weather Type in Each Country (Easy).sql
 
 
1303. Find the Team Size (Easy).sql
1303. Find the Team Size (Easy).sql
 
 
1322. Ads Performance (Easy).sql
1322. Ads Performance (Easy).sql
 
 
1327. List the Products Ordered in a Period (Easy).sql
1327. List the Products Ordered in a Period (Easy).sql
 
 
1350. Students With Invalid Departments (Easy).sql
1350. Students With Invalid Departments (Easy).sql
 
 
1378. Replace Employee ID With The Unique Identifier (Easy).sql
1378. Replace Employee ID With The Unique Identifier (Easy).sql
 
 
1407. Top Travellers (Easy).sql
1407. Top Travellers (Easy).sql
 
 
1421. NPV Queries.sql
1421. NPV Queries.sql
 
 
1435. Create a Session Bar Chart (Easy).sql
1435. Create a Session Bar Chart (Easy).sql
 
 
1484. Group Sold Products By The Date (Easy).sql
1484. Group Sold Products By The Date (Easy).sql
 
 
1495. Friendly Movies Streamed Last Month (Easy).sql
1495. Friendly Movies Streamed Last Month (Easy).sql
 
 
1511. Customer Order Frequency (Easy).sql
1511. Customer Order Frequency (Easy).sql
 
 
1517. Find Users With Valid E-Mails (Easy).sql
1517. Find Users With Valid E-Mails (Easy).sql
 
 
1527. Patients With a Condition (Easy).sql
1527. Patients With a Condition (Easy).sql
 
 
1543. Fix Product Name Format (Easy).sql
1543. Fix Product Name Format (Easy).sql
 
 
1565. Unique Orders and Customers Per Month (Easy).sql
1565. Unique Orders and Customers Per Month (Easy).sql
 
 
1571. Warehouse Manager (Easy).sql
1571. Warehouse Manager (Easy).sql
 
 
1581. Customer Who Visited but Did Not Make Any Transactions (Easy).sql
1581. Customer Who Visited but Did Not Make Any Transactions (Easy).sql
 
 
1587. Bank Account Summary II (Easy).sql
1587. Bank Account Summary II (Easy).sql
 
 
1607. Sellers With No Sales (Easy).sql
1607. Sellers With No Sales (Easy).sql
 
 
1623. All Valid Triplets That Can Represent a Country (Easy).sql
1623. All Valid Triplets That Can Represent a Country (Easy).sql
 
 
1633. Percentage of Users Attended a Contest (Easy).sql
1633. Percentage of Users Attended a Contest (Easy).sql
 
 
1661. Average Time of Process per Machine (Easy).sql
1661. Average Time of Process per Machine (Easy).sql
 
 
1667. Fix Names in a Table (Easy).sql
1667. Fix Names in a Table (Easy).sql
 
 
1677. Product’s Worth Over Invoices (Easy).sql
1677. Product’s Worth Over Invoices (Easy).sql
 
 
1683. Invalid Tweets (Easy).sql
1683. Invalid Tweets (Easy).sql
 
 
1693. Daily Leads and Partners (Easy).sql
1693. Daily Leads and Partners (Easy).sql
 
 
1729. Find Followers Count (Easy).sql
1729. Find Followers Count (Easy).sql
 
 
1731. The Number of Employees Which Report to Each Employee (Easy).sql
1731. The Number of Employees Which Report to Each Employee (Easy).sql
 
 
1741. Find Total Time Spent by Each Employee (Easy).sql
1741. Find Total Time Spent by Each Employee (Easy).sql
 
 
175. Combine Two Tables.sql
175. Combine Two Tables.sql
 
 
1757. Recyclable and Low Fat Products (Easy).sql
1757. Recyclable and Low Fat Products (Easy).sql
 
 
1777. Product’s Price for Each Store (Easy).sql
1777. Product’s Price for Each Store (Easy).sql
 
 
1789. Primary Department for Each Employee (Easy).sql
1789. Primary Department for Each Employee (Easy).sql
 
 
1809. Ad-Free Sessions (Easy).sql
1809. Ad-Free Sessions (Easy).sql
 
 
181. Employees Earning More Than Their Managers.sql
181. Employees Earning More Than Their Managers.sql
 
 
182. Duplicate Emails.sql
182. Duplicate Emails.sql
 
 
1821. Find Customers With Positive Revenue this Year (Easy).sql
1821. Find Customers With Positive Revenue this Year (Easy).sql
 
 
183. Customers Who Never Order.sql
183. Customers Who Never Order.sql
 
 
1853. Convert Date Format (Easy).sql
1853. Convert Date Format (Easy).sql
 
 
1873. Calculate Special Bonus (Easy).sql
1873. Calculate Special Bonus (Easy).sql
 
 
1890. The Latest Login in 2020 (Easy).sql
1890. The Latest Login in 2020 (Easy).sql
 
 
1939. Users That Actively Request Confirmation Messages (Easy).sql
1939. Users That Actively Request Confirmation Messages (Easy).sql
 
 
196. Delete Duplicate Emails.sql
196. Delete Duplicate Emails.sql
 
 
1965. Employees With Missing Information (Easy).sql
1965. Employees With Missing Information (Easy).sql
 
 
197. Rising Temperature.sql
197. Rising Temperature.sql
 
 
1978. Employees Whose Manager Left the Company (Easy).sql
1978. Employees Whose Manager Left the Company (Easy).sql
 
 
2026. Low-Quality Problems (Easy).sql
2026. Low-Quality Problems (Easy).sql
 
 
2072. The Winner University (Easy).sql
2072. The Winner University (Easy).sql
 
 
2082. The Number of Rich Customers (Easy).sql
2082. The Number of Rich Customers (Easy).sql
 
 
2205. The Number of Users That Are Eligible for Discount (Easy).sql
2205. The Number of Users That Are Eligible for Discount (Easy).sql
 
 
2230. The Users That Are Eligible for Discount (Easy).sql
2230. The Users That Are Eligible for Discount (Easy).sql
 
 
2329. Product Sales Analysis V (Easy).sql
2329. Product Sales Analysis V (Easy).sql
 
 
2339. All the Matches of the League (Easy).sql
2339. All the Matches of the League (Easy).sql
 
 
2356. Number of Unique Subjects Taught by Each Teacher (Easy).sql
2356. Number of Unique Subjects Taught by Each Teacher (Easy).sql
 
 
2377. Sort the Olympic Table (Easy).sql
2377. Sort the Olympic Table (Easy).sql
 
 
511. Game Play Analysis I.sql
511. Game Play Analysis I.sql
 
 
512. Game Play Analysis II.sql
512. Game Play Analysis II.sql
 
 
577. Employee Bonus.sql
577. Employee Bonus.sql
 
 
584. Find Customer Referee.sql
584. Find Customer Referee.sql
 
 
586. Customer Placing the Largest Number of Orders.sql
586. Customer Placing the Largest Number of Orders.sql
 
 
595. Big Countries.sql
595. Big Countries.sql
 
 
596. Classes More Than 5 Students.sql
596. Classes More Than 5 Students.sql
 
 
597. Friend Requests I: Overall Acceptance Rate.sql
597. Friend Requests I: Overall Acceptance Rate.sql
 
 
603. Consecutive Available Seats.sql
603. Consecutive Available Seats.sql
 
 
607.Sales Person.sql
607.Sales Person.sql
 
 
610. Triangle Judgement.sql
610. Triangle Judgement.sql
 
 
613. Shortest Distance in a Line.sql
613. Shortest Distance in a Line.sql
 
 
619. Biggest Single Number.sql
619. Biggest Single Number.sql
 
 
620. Not Boring Movies.sql
620. Not Boring Movies.sql
 
 
627. Swap Salary.sql
627. Swap Salary.sql
 
 
close