The support team logs tickets. A mistake? Click Reset lab and create the table again.
- Create
ticketswith three columns:id: a whole number that only the database gives; an INSERT that gives an id must failsubject: text, requiredopened_on: a date, required; today when the INSERT does not say
- Add three tickets with one INSERT:
Lost parcel,Wrong sizeandBroken mug. - Add a ticket with id 100 and the subject
Test. The database refuses it. The DETAIL line ends with two words that say why. Which two? - Add a ticket whose subject is NULL, and read the error. Then add the ticket
Late delivery. - Look at the
ticketstab. Which id between 1 and the newest one is missing?