Learn to write basic SQL Queries

How to use SQL Server built-in functions and create user-defined scalar functions

Create table lab: read SQL Create db and thencreate one table as described in SQLCreate Table section on w3schools (IMAGE SHOWN BELOW).Here you should show the SQL query creating the table and showingthe right side of the screen "Your Database" where the table shouldappear. Then insert some records and run Select * on it to showthat all works. Describe the meaning of the table and whatthe key is. In the following labs, you will work with yourown table.Use one of the "Select" labs but modify it t