Hello, please consider the attached Bookstore database schema and complete the following$/$let me know what queries to use on MS SQL Server:

$1.$Create the database and its tables. Use the Field Names as given and CapsLock format as given. Decide on the appropriate Data Types.

$2.$Use the INSERT queries below to add rows to the associated tables:

$$EMPLOYEE TABLE:

$$INSERT INTO EMPLOYEE

$$VALUES $(1,$'John', 'Doe', $1),$

$(2,$'Jane', 'Smith', $2),$

$(3,$'Bob', 'Johnson', $1)$;

$$DEPARTMENT TABLE:

$$INSERT INTO DEPARTMENT

VALUES $(1,$'Sales'$),$

$(2,$'Marketing'$)$;

SALESORDER TABLE:

$$INSERT INTO SALESORDER

VALUES $(101,1,\text{'}2024-04-01\text{'},1000\mathrm{.}00),$

$(102,2,\text{'}2024-04-05\text{'},1500\mathrm{.}50),$

$(103,3,\text{'}2024-04-10\text{'},2000\mathrm{.}75)$;

$3.$After inserting the rows to the tables, create the appropriate SQL queries to achieve the following tasks.

$3\mathrm{.}1.$Retrieve all employees whose first name starts with $\text{'}$J$\text{'}.$

$3\mathrm{.}2.$Retrieve all orders placed between April $1$st$,2024$ and April $10$th$,2024.$

$3\mathrm{.}3.$Retrieve all departments with DepartmentID $1$ and $2.$

$3\mathrm{.}4.$Retrieve all employees who have been assigned to a department.

$3\mathrm{.}5.$Retrieve distinct combinations of EmployeeID, FirstName, and LastName from the EMPLOYEE table.

$3\mathrm{.}6.$Retrieve EmployeeID, FirstName, LastName, and DepartmentName of all employees along with their corresponding departments.

$3\mathrm{.}7.$Retrieve EmployeeID, FirstName, LastName, and OrderDate of all employees and their orders. Include all employees even if they haven't placed any orders. Hint LEFT JOIN.

$3\mathrm{.}8.$Retrieve EmployeeID, FirstName, LastName, and OrderDate of all employees and their orders. Include all employees even if they haven't placed any orders. Hint OUTER JOIN.

$3\mathrm{.}9.$Retrieve all orders placed on or after April $1$st$,2024.$

$3\mathrm{.}10.$Add a new column 'Email' to the EMPLOYEE table. The column must have a length of $100.$

$3\mathrm{.}11.$Retrieve EmployeeID, FirstName, and LastName of employees who belong to the 'Sales' department.

Thank You