Answer:
Explanation:
The objective of this task is to compute a program that involves the usage of Python code to save the data to MongoDB and to query the database.
Due to the error that occur which makes me to be unable to submit this answer, I've created a word document instead and the attached file can be found below.
Thanks!
Answer:
SELECT last_name, job_title, hire_date FROM employee WHERE hire_date>="01-12-2016" AND job_title != "STOCK CLERK" ORDER BY job_title DESC;
Explanation:
The SQL code queries the employee table returning records of the last_name, job_title, and hire_date columns matching the employees hired on or after December 2016 and job titles that are not stock clerks in the employee table.
The WHERE and AND clause is responsible for the condition while the ORDER BY clause returns the query result in the of the job title in descending order.
Answer:
False
Explanation:
You can change it to landscape
