Skip to content
BranchesTags

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

99 Commits
B-PARTITION BY vs. GROUP BY
B-PARTITION BY vs. GROUP BY
 
 
B-Where vs. Having Difference
B-Where vs. Having Difference
 
 
E-1050w1-r1. Actors and Directors Who Cooperated At Least Three Times
E-1050w1-r1. Actors and Directors Who Cooperated At Least Three Times
 
 
E-1068. Product Sales Analysis I
E-1068. Product Sales Analysis I
 
 
E-1069. Product Sales Analysis II
E-1069. Product Sales Analysis II
 
 
E-1075w1-r1. Project Employees I
E-1075w1-r1. Project Employees I
 
 
E-1076w2. Project Employees II
E-1076w2. Project Employees II
 
 
E-1082w2. Sales Analysis I
E-1082w2. Sales Analysis I
 
 
E-1083w2. Sales Analysis II
E-1083w2. Sales Analysis II
 
 
E-1084. Sales Analysis III
E-1084. Sales Analysis III
 
 
E-1113w1. Reported Posts
E-1113w1. Reported Posts
 
 
E-1141. User Activity for the Past 30 Days I
E-1141. User Activity for the Past 30 Days I
 
 
E-1142w1. User Activity for the Past 30 Days II
E-1142w1. User Activity for the Past 30 Days II
 
 
E-1148. Article Views I
E-1148. Article Views I
 
 
E-1173w1. Immediate Food Delivery I
E-1173w1. Immediate Food Delivery I
 
 
E-1179w1. Reformat Department Table
E-1179w1. Reformat Department Table
 
 
E-1251w1. Average Selling Price
E-1251w1. Average Selling Price
 
 
E-1280w2. Students and Examinations
E-1280w2. Students and Examinations
 
 
E-1294w1. Weather Type in Each Country
E-1294w1. Weather Type in Each Country
 
 
E-1303w1. Find the Team Size
E-1303w1. Find the Team Size
 
 
E-1322w1. Ads Performance
E-1322w1. Ads Performance
 
 
E-1327. List the Products Ordered in a Period
E-1327. List the Products Ordered in a Period
 
 
E-1350w1. Students With Invalid Departments
E-1350w1. Students With Invalid Departments
 
 
E-1407w1. Top Travellers
E-1407w1. Top Travellers
 
 
E-1435w1. Create a Session Bar Chart
E-1435w1. Create a Session Bar Chart
 
 
E-1484w1. Group Sold Products By The Date
E-1484w1. Group Sold Products By The Date
 
 
E-1495. Friendly Movies Streamed Last Month
E-1495. Friendly Movies Streamed Last Month
 
 
E-1511w1. Customer Order Frequency
E-1511w1. Customer Order Frequency
 
 
E-1517w1. Find Users With Valid E-Mails
E-1517w1. Find Users With Valid E-Mails
 
 
E-1527w1c1. Patients With a Condition
E-1527w1c1. Patients With a Condition
 
 
E-1543w1. Fix Product Name Format
E-1543w1. Fix Product Name Format
 
 
E-1565w1. Unique Orders and Customers Per Month
E-1565w1. Unique Orders and Customers Per Month
 
 
E-1571w1. Warehouse Manager
E-1571w1. Warehouse Manager
 
 
E-1581w1. Customer Who Visited but Did Not Make Any Transactions
E-1581w1. Customer Who Visited but Did Not Make Any Transactions
 
 
E-1587w1. Bank Account Summary II
E-1587w1. Bank Account Summary II
 
 
E-1607. Sellers With No Sales
E-1607. Sellers With No Sales
 
 
E-1623w1. All Valid Triplets That Can Represent a Country
E-1623w1. All Valid Triplets That Can Represent a Country
 
 
E-1633w1. Percentage of Users Attended a Contest
E-1633w1. Percentage of Users Attended a Contest
 
 
E-1661w1. Average Time of Process per Machine
E-1661w1. Average Time of Process per Machine
 
 
E-1667w2. Fix Names in a Table
E-1667w2. Fix Names in a Table
 
 
E-1677w1. Product's Worth Over Invoices
E-1677w1. Product's Worth Over Invoices
 
 
E-1683w1. Invalid Tweets
E-1683w1. Invalid Tweets
 
 
E-1693w1. Daily Leads and Partners
E-1693w1. Daily Leads and Partners
 
 
E-1729w1. Find Followers Count
E-1729w1. Find Followers Count
 
 
E-1731w1. The Number of Employees Which Report to Each Employee
E-1731w1. The Number of Employees Which Report to Each Employee
 
 
E-1741w1. Find Total Time Spent by Each Employee
E-1741w1. Find Total Time Spent by Each Employee
 
 
E-175. Combine Two Tables
E-175. Combine Two Tables
 
 
E-1757. Recyclable and Low Fat Products
E-1757. Recyclable and Low Fat Products
 
 
E-176w1. Second Highest Salary
E-176w1. Second Highest Salary
 
 
E-1777w1. Product's Price for Each Store
E-1777w1. Product's Price for Each Store
 
 
E-1789w1. Primary Department for Each Employee
E-1789w1. Primary Department for Each Employee
 
 
E-1795w1. Rearrange Products Table
E-1795w1. Rearrange Products Table
 
 
E-1809w1. Ad-Free Sessions
E-1809w1. Ad-Free Sessions
 
 
E-181w1. Employees Earning More Than Their Managers
E-181w1. Employees Earning More Than Their Managers
 
 
E-182. Duplicate Emails
E-182. Duplicate Emails
 
 
E-1821. Find Customers With Positive Revenue this Year
E-1821. Find Customers With Positive Revenue this Year
 
 
E-183. Customers Who Never Order
E-183. Customers Who Never Order
 
 
E-196w1. Delete Duplicate Emails
E-196w1. Delete Duplicate Emails
 
 
E-197w1. Rising Temperature
E-197w1. Rising Temperature
 
 
E-511. Game Play Analysis I
E-511. Game Play Analysis I
 
 
E-512w1. Game Play Analysis II
E-512w1. Game Play Analysis II
 
 
E-577w1. Employee Bonus
E-577w1. Employee Bonus
 
 
E-584w1. Find Customer Referee
E-584w1. Find Customer Referee
 
 
E-586w1. Customer Placing the Largest Number of Orders
E-586w1. Customer Placing the Largest Number of Orders
 
 
E-595. Big Countries
E-595. Big Countries
 
 
E-596. Classes More Than 5 Students
E-596. Classes More Than 5 Students
 
 
E-597w1. Friend Requests I: Overall Acceptance Rate
E-597w1. Friend Requests I: Overall Acceptance Rate
 
 
E-603w1. Consecutive Available Seats
E-603w1. Consecutive Available Seats
 
 
E-607w1. Sales Person
E-607w1. Sales Person
 
 
E-613w1. Shortest Distance in a Line
E-613w1. Shortest Distance in a Line
 
 
E-619w1. Biggest Single Number
E-619w1. Biggest Single Number
 
 
E-627w1. Swap Salary
E-627w1. Swap Salary
 
 
M-180w1. Consecutive Numbers
M-180w1. Consecutive Numbers
 
 
M-184w1. Department Highest Salary
M-184w1. Department Highest Salary
 
 
README.md
README.md
 
 

Repository files navigation

SQL

About

No description, website, or topics provided.

Resources

Readme
Activity

Stars

4 stars

Watchers

1 watching

Forks

2 forks
Report repository

Releases

Packages

Contributors