Switch to the Melbourne Swim Teams In cell B14, use the INDEX function to display the value in the first row and first column of the SwimTeams table

Please explain the purpose of the GROUPING SETS clause and its primary use.

10. Produce a list of each customer number and the third and fourth digits of his or her zipcode. The query should also display the position of the first occurrence of a 3 in thecustomer number, if it exists. SQL commands

MS-ACCESS (. 1. Create a database COMPANY and create a new table EMPOLYEE and name it 2. Design a table EMPOLYEE so that it has all fields and the following properties FIELDS DATATYPE PROPERTIES EMPNO Number 4 EMPNAΜΕ Short Text 10 PHONE Number 8 PLACE Short Text 9. DOJ Date/Time 3. Set the field EMPNO as the primary key and save the table 4. Enter the following data into the table EMPLOYEE EMPNO ΕMPNAΜΕ PHONE PLACE DOJ 1111 ΑΗMED 98989898 | IBRI 12/06/2014 2222 SARA 99997777 | NIZWA 15/09/2018 3333 AMNA 90909090 | MUSCAT 14/06/2017 4444 NAHID 91919191 IBRI 02/08/2015 5. Design a table SPORTS so that it has all fields and the following properties FIELDS DATATYPE PROPERTIES EMPNO Number 4 SPORTS Short Text 10 YEARS Number 2 SCHOLARSHIP YES/NO AMOUNT CURRENCY 6. Set the field EMPNO as the primary key and save the table 7. Enter the following data into the table SPORTS EMPNO SPORTS YEARS SCHOLARSHIP AMOUNT 4444 FOOTBALL YES 50 3333 BASKETBALL NO 2222 FOOTBALL 1 NO 1111 CRICKET YES 50 8.…