Subqueries and JOINs - Exercise

Problems

01. Booked for Nights

Problem Description

Database

Database

02. First 10 Apartments Booked At

03. First 10 Customers with Bookings

04. Booking Information

06. Unassigned Apartments

07. Bookings Made by Lead

08. Hahn`s Bookings

09. Total Sum of Nights

10. Popular Vacation Destination

11. Bulgaria's Peaks Higher than 2835 Meters

12. Count Mountain Ranges

13. Rivers in Africa

14. Minimum Average Area Across Continents

15. Countries Without Any Mountains

16. Monasteries by Country

17. Monasteries by Continents and Countries

18. Retrieving Information about Indexes

19. Continents and Currencies

20. The Highest Peak in Each Country