Given the structure and contents of the Ch07_ConstructCo database shown in FigureP7.1, use SQL commands to answer the following problems.Write the SQL code required to list the employee number, last name, first name, andmiddle initial of all employees whose last names start with Smith. In other words, therows for both Smith and Smithfield should be included in the listing. Sort the resultsby employee number. Assume case sensitivity

Complete the following Updating Data Activities using SQL. After completing the required SQL activity, use a Select clause after each activity to display the fields changed to prove the results is correct. 1. Change the description of part BT04 to Oven. 2. Add $100 to the credit limit of every customer represented by sales rep number 06. 3. Add order 12600 (order date: 09/06/2018, customer number: 311) to the database. Add two order lines to this order. On the first line, the part number is AX12, the number ordered is 5, and the quoted price is $13.95. On the second line, the part number is BA74, the number ordered is 3, and the quoted price is $4.50. 4. Write the command to delete every customer whose balance is $0 and who is represented by sales rep 12. Do not execute the command. 5. Create a new table named SPGOOD to contain the columns PART_NUMBER, DESCRIPTION, and UNIT_PRICE. Then insert into this new table the part number, part description, and unit price from the PART table…

Please help with the following: Using oracle sql live or sql developer what sql statements could be use to find the following: A simple database composed of the following tables: PATIENT, DOCTOR, DRUG, and PRESCRIPTION. Please explore the database and then write the appropriate SQL command. List doctor’s details where speciality is either Dermatology or Neurology. (Use INoperator). List the results by the first name in ascending order and the last name indescending order. Find all patients rows whose first names include ‘George’ (Assume case sensitivity). sql doc below Beginfor c in (select table_name from user_tables) loopexecute immediate ('drop table '||c.table_name||' cascade constraints');end loop;End;//* */ ALTER SESSION SET NLS_DATE_FORMAT = 'MM/DD/YYYY';CREATE TABLE DOCTOR (DOC_ID varchar2(5) PRIMARY KEY,DOC_LNAME varchar2(15),DOC_FNAME varchar2(15),DOC_INITIAL varchar2(1),DOC_SPECIALTY varchar2(15));INSERT INTO DOCTOR…

please use SQL to answer the following question an erd had been provide as well

How do I do this question in SQL command?  Use the Oracle database employees table and CASE expression to decode the departmentid. Display the department id, last name, salary, and a column called “New Salary” whose value is based on the following conditions: If the department id is 10 then 1.25 * salary If the department id is 90 then 1.5 * salaryIf the department id is 130 then 1.75 * salary Otherwise, display the old salary.

This is in sql. For all artists who are currently in a band: Return the artist’s full name (as a single value), the band name, and how long in years the artist has been in the band. The artist should only be shown once for  each band. (Hint: Remember that the data might include an artist who left a band and then rejoined. That is the challenge here!)   Tables with values are in image.

8. Using today’s date, determine the age (in months) of each book that JustLee sells. Makesure only whole months are displayed; ignore any portions of months. Display the book title,publication date, current date, and age. SQL commands

Write queries in SQL to answer each of the following questions: 1. Find all students in Comp. Sci. dept 2. Find all students with total credits > 100 3. Find all students who took course in Spring 2010 (Remove duplicates please) 4. Find all courses taken by the student whose ID is 76543 and also find his name create table student (ID varchar(5), name varchar(20) not null, dept_name varchar(20), tot_cred numeric(3,0), primary key (ID) ); create table takes (ID varchar(5), course_id varchar(8), sec_id varchar(8), semester varchar(6), year numeric(4,0), grade varchar(2), primary key (ID, course_id, sec_id, semester, year) ); insert into student values ('00128', 'Zhang', 'Comp. Sci.', '102'); insert into student values ('12345', 'Shankar', 'Comp. Sci.', '32'); insert into student values ('19991', 'Brandt', 'History', '80'); insert into student values ('23121', 'Chavez', 'Finance', '110'); insert into student values ('44553', 'Peltier', 'Physics', '56'); insert into student values…

Write a SQL query to find the customer# of those customers that purchased at least once in July 2020 but NOT in August 2020. In addition to the customer#, show the ISBN and title of the book(s) they purchased in July 2020. You may use only one query. No creating any temporary tables or subqueries. You may use only joins. SUBMIT a second solution in addition to your Level 1.

Write the T-SQL scripts for the following tasks: Write a query to list the first name and last name of the employee with the highest salary in the financedepartment