8, Dec 2020
Use SQL

Open the mydb database we created earlier and create a new department table with

two fields:

documentid (as an integer field)

Jsondocument (as a JSON field)

And add around 3 departments and each with 2 or 3 employees. See example on slide #39-41

of the JSONDataType PowerPoint.

Part 2: Use SQL to answer the following questions:

Q1: Select all the records in the table.

Q2: List the department names with their phones.

Q3: A query to show the deptName and number of employees of the department.

Q4: A query to show all the employees of a department of your choice using deptName as

criteria