SQL challenges
8 challenges, from warm-ups to the tricky ones. Solve them in any order.
Customers in IndiaList the names of customers who live in India. SolvedEasy+30 XPProducts under 40Find the cheaper products and their prices. SolvedEasy+30 XPOut of stockWhich products have run out? SolvedEasy+30 XPCustomers per countryCount customers in each country. SolvedMedium+50 XPAverage salary by departmentSummarise salaries per department. SolvedMedium+50 XPOrders with customer namesJoin orders to customers. SolvedMedium+50 XPOrder totalsAdd up what each order is worth. SolvedHard+80 XPCustomers who never orderedFind customers with no orders at all. SolvedHard+80 XP
No challenges at that level yet.