Answer these questions

INSERT INTO EMPLOYEE VALUES (101,' 'Adam',' Smith','Manager', 102,' 1998-04-12') ; INSERT INTO EMPLOYEE VALUES (102, 'Marry', 'Jane', 'CEO',NULL, '1997-01-18') ; INSERT INTO EMPLOYEE VALUES (103, 'Eliza',' Rynd','Manager', 102, '1999-03-07') INSERT INTO EMPLOYEE VALUES (104,'Imran',' Khan','Sales', 101, '2003-04-17'); INSERT INTO EMPLOYEE VALUES (105,' Wally', 'Ham',' Sales', 101,'2006-06-21') INSERT INTO EMPLOYEE VALUES (106,' Jack', 'Hobbs', 'Sales', 101,'2000-07-12') ; INSERT INTO EMPLOYEE VALUES (107,' Don','Bradman', 'Advertising', 101, '2014-09-18'); INSERT INTO EMPLOYEE VALUES (108, 'Nawab', 'Pat', 'Accounts', 103, '2008-02-02') ; INSERT INTO EMPLOYEE VALUES (109,' Jack', 'Odumbe', 'Accounts', 103,'2016-03-01') ; INSERT INTO SHIFT VALUES (1, 'Monday', 0900,1700); INSERT INTO SHIFT VALUES (2, 'Tuesday", 0900,1700); INSERT INTO SHIFT VALUES (3,'Wednesday", 0900,1700); INSERT INTO SHIFT VALUES (4, "Thursday", 0900, 1700); INSERT INTO SHIFT VALUES (5, 'Friday', 0900,1700); INSERT INTO SHIFT VALUES (6, ' Friday', 1200,2000); INSERT INTO SHIFT VALUES (7, 'Saturday', 0900,1700); INSERT INTO SHIFT VALUES(8, 'Saturday", 1200, 2000); INSERT INTO SHIFT VALUES (9, 'Sunday', 1000,1600); INSERT INTO TRANSACTION VALUES (1001,1005,1001,105,20180412,20180422,20180426 '); INSERT INTO TRANSACTION VALUES (1002,1006,1004,104,20180418,20180428,20180429); INSERT INTO TRANSACTION VALUES (1003,1003,1005,104,20180412,20180421,20180422 '); INSERT INTO TRANSACTION VALUES (1005,1008,1006,106,20180421,20180423,20180425 '); INSERT INTO TRANSACTION VALUES ( 1006,1001,1001,106,20180421,201804299,20180521); Write a query to display the number of transactions for each type of car. The output should have a separate row for each type of car such as sedan, hatch, ute etc. [2 marks] Task 22 Write a query to identify emails addresses that are incorrect (missing @). Provide a screenshot of the output. [2 marks] Task 23 Write a query to display the day on which the CEO joined the company. Hint: There are functions that can be used to display day of week for dates. [2 marks] Task 24 Write a query to display information about the current user (This is the user you have logged in as) Hint: Data dictionary. [2 marks]