Tracks/Foundations
Foundations
SELECT, filter, sort, and limit — the queries every interview starts with.
SELECT
WHERE
ORDER BY
LIMIT
DISTINCT
0/112 solved
- 1—001. Select All Employeeseasy
- 2—002. Filter Employees by Salaryeasy
- 3—003. Order Employees by Salaryeasy
- 4—005. Employees With Departmentseasy
- 5—006. Distinct Job Titleseasy
- 6—007. Top 5 Highest-Paid Employeeseasy
- 7—008. Employees Hired After 2022easy
- 8—009. Employees Without a Managereasy
- 9—010. Total Salary Budgeteasy
- 10—011. Average Product Priceeasy
- 11—012. Most Expensive Producteasy
- 12—013. Cheapest Producteasy
- 13—014. Customer Count by Countryeasy
- 14—015. Products Out of Stockeasy
- 15—016. Employees With No Departmenteasy
- 16—017. Salary Tier Labeleasy
- 17—018. Customer Name Searcheasy
- 18—019. Orders in a Price Rangeeasy
- 19—020. Customers from Specific Citieseasy
- 20—021. Coalesce Missing Department Nameeasy
- 21—022. Uppercase Product Nameseasy
- 22—023. Extract Order Yeareasy
- 23—024. Total Orders per Customereasy
- 24—025. Count Unique Product Categorieseasy
- 25—026. Orders with Status Pendingeasy
- 26—027. Employees Earning Above 100keasy
- 27—028. Sort Products by Price Descendingeasy
- 28—029. Paginate Products (Page 3, 5 per page)easy
- 29—030. Monthly Order Counteasy
- 30—101. String Length Functioneasy
- 31—102. UPPER and LOWER String Functionseasy
- 32—103. Trim Leading and Trailing Whitespaceeasy
- 33—104. Concatenate First and Last Nameeasy
- 34—105. Extract Category Code from SKUeasy
- 35—106. Replace Words in Review Texteasy
- 36—107. Filter Orders by Dateeasy
- 37—108. Extract Year from Hire Dateeasy
- 38—109. Find Orders Placed in Septembereasy
- 39—110. Calculate Project Duration in Dayseasy
- 40—111. Round Discounted Priceseasy
- 41—112. Ceiling and Floor of Order Amountseasy
- 42—113. Find Accounts Far from Target Balanceeasy
- 43—114. Find Products with Quantity Divisible by 3easy
- 44—115. Calculate Square Area and Diagonaleasy
- 45—116. Return First Available Phone Numbereasy
- 46—117. Avoid Division by Zero with NULLIFeasy
- 47—118. Find Top-Level Employees with No Managereasy
- 48—119. Find Products with a Descriptioneasy
- 49—120. Filter Employees by Salary Rangeeasy
- 50—121. Filter Products by Category Using INeasy
- 51—122. Exclude Cancelled and Returned Orderseasy
- 52—123. Find Gmail Customers Using LIKEeasy
- 53—124. Match Employee Codes with _ Wildcardeasy
- 54—125. Find Products NOT Starting with Seasy
- 55—126. Filter with Multiple AND Conditionseasy
- 56—127. Filter with Multiple OR Conditionseasy
- 57—128. Mix AND and OR with Parentheseseasy
- 58—129. Total Amount Spent per Customereasy
- 59—130. Average Rating per Producteasy
- 60—131. Most Recent Hire Date per Departmenteasy
- 61—132. First Product Name Alphabetically per Categoryeasy
- 62—133. COUNT(*) vs COUNT(column)easy
- 63—134. Count Distinct Customerseasy
- 64—135. Map Status Codes to Labels with CASE WHENeasy
- 65—136. Assign Salary Grade with CASE WHEN Rangeseasy
- 66—137. Handle NULL Bonus with CASE WHENeasy
- 67—138. Sort by Department and Salaryeasy
- 68—139. Sort Products by Profit Margineasy
- 69—140. Paginate Results with LIMIT and OFFSETeasy
- 70—141. Top 5 Orders by Amount Using FETCH FIRSTeasy
- 71—142. Rename Columns with AS Aliaseasy
- 72—143. Use Table Aliases in a JOINeasy
- 73—144. Calculate Price Including Taxeasy
- 74—145. Join Orders with Customer Detailseasy
- 75—146. Find Customers Who Have Never Orderedeasy
- 76—147. List All Unique Order Statuseseasy
- 77—148. Find Unique Department-City Combinationseasy
- 78—149. Count Orders by Statuseasy
- 79—150. Total Revenue by Department and Quartereasy
- 80—151. Customers Who Spent More Than $500easy
- 81—152. Products Ordered by More Than 2 Customerseasy
- 82—153. Group Orders by Month Using DATE_TRUNCeasy
- 83—154. Find Active Subscriptions After a Dateeasy
- 84—155. Pad Invoice Numbers with LPADeasy
- 85—156. Reverse Strings and Detect Palindromeseasy
- 86—157. Find the Position of @ in Email Addresseseasy
- 87—158. CHAR_LENGTH vs LENGTH on Messageseasy
- 88—159. Replace NULL Commission with IFNULLeasy
- 89—160. Find Employees Earning Above Average Salaryeasy
- 90—301. Compute Profit per Producteasy
- 91—303. Find Employees in a Named Departmenteasy
- 92—304. Products Below Reorder Leveleasy
- 93—305. Extract Day of Week from Order Dateeasy
- 94—306. Find Customers with No Phone Numbereasy
- 95—307. Calculate Salary After a 10% Bonuseasy
- 96—308. Products Whose Name Starts with 'A'easy
- 97—310. Filter Orders by a Specific Dateeasy
- 98—311. Sort Employees by Hire Dateeasy
- 99—313. Find the Highest and Lowest Salaryeasy
- 100—314. Customers with Long Nameseasy
- 101—315. Uppercase Product Nameseasy
- 102—316. Score Remainder with the Modulo Operatoreasy
- 103—317. Calculate the Discount Amount per Producteasy
- 104—319. Orders in a Date Range (BETWEEN)easy
- 105—320. Count NULL Values in a Columneasy
- 106—321. Assign Letter Grades with CASE WHENeasy
- 107—322. Fetch the First 3 Products Alphabetically (LIMIT)easy
- 108—323. Filter Employees by Status Using INeasy
- 109—324. Format Order IDs with Zero-Paddingeasy
- 110—327. Pick the First Non-NULL Name with COALESCEeasy
- 111—329. Customers Who Have Placed at Least One Ordereasy
- 112—330. Combine Employees and Contractors with UNIONeasy