Instructions Write SQL queries to solve the following problems. We will be using the “university” database. All queries should involve only the instructor table. After you are done, save your work as .sql file and turn in the .sql file into Moodle for grading. Write a SQL statement to display all columns using the SQL asterisk (*) wild-card character. Write a SQL statement to display ID and name of the instructors (ID appears first). Write a SQL statement to display department names. Write a SQL statement to display unique department names. (expect 7 rows returned) Write a SQL statement to display all info about instructors having a salary greater than 75000. (expect 6 rows returned) Write a SQL statement to display department name, instructor name, and salary for instructors that have a salary less than 70000. Sort the results in ascending order by department name. (expect 4 rows returned) Write a SQL statement to display name, department name, and salary for instructors that have a salary less than 90000 and are in the department of “History”. Sort the results in ascending order by department name and in descending order by salary. (expect 2 rows returned) Write an SQL statement to display ID, name, and salary for all instructors having a salary greater than 61000 and less than 80000. (expect 4 rows returned) Write a SQL statement to show everything for all instructor with an ID starting with ‘76’. (expect 2 rows returned) Note: The ID field of the instructor table is a varchar type instead of int to make this query valid. Write a SQL statement to show ID and name for all instructors with a department name that includes the word ‘Sci’. (expect 3 rows returned) Write a SQL statement to show ID and name for all instructors with an ‘a’ in the second position from the left in their names. (expect 2 rows returned)
Instructions Write SQL queries to solve the following problems. We will be using the “university” database. All queries should involve only the instructor table. After you are done, save your work as .sql file and turn in the .sql file into Moodle for grading. Write a SQL statement to display all columns using the SQL asterisk (*) wild-card character. Write a SQL statement to display ID and name of the instructors (ID appears first). Write a SQL statement to display department names. Write a SQL statement to display unique department names. (expect 7 rows returned) Write a SQL statement to display all info about instructors having a salary greater than 75000. (expect 6 rows returned) Write a SQL statement to display department name, instructor name, and salary for instructors that have a salary less than 70000. Sort the results in ascending order by department name. (expect 4 rows returned) Write a SQL statement to display name, department name, and salary for instructors that have a salary less than 90000 and are in the department of “History”. Sort the results in ascending order by department name and in descending order by salary. (expect 2 rows returned) Write an SQL statement to display ID, name, and salary for all instructors having a salary greater than 61000 and less than 80000. (expect 4 rows returned) Write a SQL statement to show everything for all instructor with an ID starting with ‘76’. (expect 2 rows returned) Note: The ID field of the instructor table is a varchar type instead of int to make this query valid. Write a SQL statement to show ID and name for all instructors with a department name that includes the word ‘Sci’. (expect 3 rows returned) Write a SQL statement to show ID and name for all instructors with an ‘a’ in the second position from the left in their names. (expect 2 rows returned)
Chapter12: Subqueries And Merge Statements
Section: Chapter Questions
Problem 19MC
Related questions
Question
Instructions
Write SQL queries to solve the following problems. We will be using the “university”
- Write a SQL statement to display all columns using the SQL asterisk (*) wild-card character.
- Write a SQL statement to display ID and name of the instructors (ID appears first).
- Write a SQL statement to display department names.
- Write a SQL statement to display unique department names. (expect 7 rows returned)
- Write a SQL statement to display all info about instructors having a salary greater than 75000. (expect 6 rows returned)
- Write a SQL statement to display department name, instructor name, and salary for instructors that have a salary less than 70000. Sort the results in ascending order by department name. (expect 4 rows returned)
- Write a SQL statement to display name, department name, and salary for instructors that have a salary less than 90000 and are in the department of “History”. Sort the results in ascending order by department name and in descending order by salary. (expect 2 rows returned)
- Write an SQL statement to display ID, name, and salary for all instructors having a salary greater than 61000 and less than 80000. (expect 4 rows returned)
- Write a SQL statement to show everything for all instructor with an ID starting with ‘76’. (expect 2 rows returned) Note: The ID field of the instructor table is a varchar type instead of int to make this query valid.
- Write a SQL statement to show ID and name for all instructors with a department name that includes the word ‘Sci’. (expect 3 rows returned)
- Write a SQL statement to show ID and name for all instructors with an ‘a’ in the second position from the left in their names. (expect 2 rows returned)
AI-Generated Solution
AI-generated content may present inaccurate or offensive content that does not represent bartleby’s views.
Unlock instant AI solutions
Tap the button
to generate a solution
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:
9781337102124
Author:
Diane Zak
Publisher:
Cengage Learning
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:
9781337102124
Author:
Diane Zak
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning