c] Write an SQL statement to create a view called sales giving for each workshop, the workshopID, title, session date (formatted as DD/MM/YYYY and called date), total number of tickets sold for that workshop (as total Sales) and number of tickets remaining.

Member memberi 1000 1001 1002 firstName Aksha Eric Zhe surname Shaikh Rostron Ding phone 0456123456 0439774776 0459914321 Workshop workshops 100 101 102 title Firing a steam locomotive Rail signalling Shunt rolling stock sessionDate 2021-12-31 2021-12-17 2021-02-03 price 89.95 55.50 78.00 qtyRemaining 2 9 6 Booking memberi 1001 1000 workshoplD 102 101 qtyTickets 2 1 1002 102 1