Table of Contents
Complete the following steps:
- Complete reading and viewing all the learning resources specified for this module.
- Using either the DB Browser or the DBeaver GUI you downloaded, run the queries provided by your instructor against the SQLite3 university database to see the results, and copy the QUERY and the OUTPUT to a text or WORD document.
- Using either the DB Browser or the DBeaver GUI, write SQL commands for the following exercises and run them against the SQLite3 university database and copy the QUERY and the OUTPUT to the text or WORD Document
-
- List all the department names of the instructors.
- List all the names of the instructors whose salaries are between 90,000 and 100,000.
- List all the instructors’ names and the classes they teach.
- List all the instructors inthe Biology department.
- List the average salary of the insturctors in the Computer Science department.
- Insert your name into the instructor table and assign yourself to the Computer Science department and give yourself a salary of 80000
- Update your salary to 90000.
NOTE: Refer to the following website for additional help:
4. Submit all the SQL query results you saved in the text or WORD file.
What Students Are Saying About Us
.......... Customer ID: 12*** | Rating: ⭐⭐⭐⭐⭐"Honestly, I was afraid to send my paper to you, but you proved you are a trustworthy service. My essay was done in less than a day, and I received a brilliant piece. I didn’t even believe it was my essay at first 🙂 Great job, thank you!"
.......... Customer ID: 11***| Rating: ⭐⭐⭐⭐⭐
"This company is the best there is. They saved me so many times, I cannot even keep count. Now I recommend it to all my friends, and none of them have complained about it. The writers here are excellent."
“Order a custom Paper on Similar Assignment at essayfount.com! No Plagiarism! Enjoy 20% Discount!”
