2.1 SQL statements 2.1.1 Button [2.1.1 - List of bookings] Display the booking number and the learner driver name and surname of all bookings with Bellville as test venue - NSC Information Technology - Question 2 - 2022 - Paper 1

The update query should be structured as follows to change the test venue to 'Headquarters' for records without a venue:

UPDATE tblBookings
SET TestVenue = 'Headquarters'
WHERE TestVenue IS NULL;

To display the booking number and details for bookings in Bellville, the same query can be used from the previous step, as shown:

SELECT BookingNum, DriverName, DriverSurname
FROM tblBookings
WHERE TestVenue = 'Bellville';

To count the number of bookings for each type of licence, utilize the query:

SELECT LEFT(BookingNum, 1) AS LicenceType, COUNT(*) AS NumberOfBookings
FROM tblBookings
GROUP BY LEFT(BookingNum, 1);

To delete records from tblBookings where the TestVenue is 'Pretoria' and the BookingDate falls within the specified range:

DELETE FROM tblBookings
WHERE TestVenue = 'Pretoria'
AND BookingDate BETWEEN '2022-05-18' AND '2022-05-25';