Bays Rented 2+ Times

HardGrade 12
📜Adapted from a real exam — IEB November 2023, Paper I, Section A. View the original paper →

Determine how many times each parking bay has been rented out. Show the Address and the number of times rented (as TimesRented) for bays rented 2 or more times.

Database

RentMyParking

A company renting out parking bays to car owners. Adapted from a real IEB exam — premium bays are covered and secured, and a car can be parked at any bay on any given day.

query.sql

Loading in-browser database…

Run your query to see results here.