Hi really need help with this assignment Oracle 12c: SQL Chapter 8 Question 3 and 5. 3. List the titles, retail price, and discount for all books that contain the word "cook" in the title. Sort by cost. 5. List titles, cost, retail and profit margin for all books that have a profit margin under 55%. Make sure to assign a descriptive column name for the calculated field. Profit margin is calculating by the following formula: ((retail – cost) / cost) *100

Q: Display the list of students who are involved in the IT club Display the details of all the…

A: First get the studid from Club table and then get those Student details This can be done using inner…

Q: https://www.w3schools.com/sql/trysql.asp?filename=trysql_select_all DATA BASE Question 1: Write…

A: The SELECT command is utilized for finding and printing the tuples from a database table. It has…

Q: Use the following table to find the OUTPUT of the following SQL queries: Table Name: Patients…

A: Answer :--  Jan-12-01

Q: Create a function name BALANCE that returns the status of outstanding amount for each customer. Use…

A: Required : Function name : BALANCE It returns the status of outstanding amount for each customer. IF…

Q: SQL code for (see image for the table structure): Create a stored procedure “changeCreditLimit” to…

A: The solution is an given below :

Q: CUSTOMER Customer table is composed of customer number, name and phone number. Give and fill-in the…

A: Answer:- Atrributes: It is a column in a table Table CUSTOMER: Atrributes : 1.custID( Type),…

Q: Use SQL Developer or Oracle Live SQL to write the appropriate SQL commands as follows: A) FUNCTION:…

A: Answer: Oracle: CREATE FUNCTION Return_region_name(region_id IN NUMBER)RETURN NUMBERIS region_name…

Q: In sql get to know the HR database, its tables, and their contents. Show the SQL query and the…

A: SQL: SQL stands for a structured query language, it used to manage the data and organize the data in…

Q: Database course:  Write SQL queries to do the following    A. List names of IT students.…

A: The SQL queries are given in step 2.

Q: Create the following table in your database with the following schema: Table: Users I Column Name 1…

A: We need to provide sql query codes  for the given database schema

Q: Using the Online SQL Editor, answer the following questions with screenshots. Link:…

A: SQL stands for Structure Query Language. SQL is a widely used language to manage databases in…

Q: In the following PL/SQL block, determine the values and data types for each of the following cases:…

A: conclusion:In the nested block:v_customer holds a numeric value of 201 with a data type of…

Q: The following figure is part of a university database. LNAME and FNAME stands for last name and…

A: Project operation (denoted by pi (∏) symbol) is used to select desired columns (or attributes) from…

Q: write DQL statement to do the following (and a screenshot of the result): 1. Find cities that exists…

A: SELECT * FROM Customers, Suppliers WHERE Customers.City = Suppliers.City;

Q: 9. Determine the calendar date of the next occurrence of Wednesday, based on today’s date. SQL…

A: Solution: Introduction: Sql - structured query language  To Determine the calendar date of the next…

Q: Write a SQL code that returns the Name of ALL Customers (based on CUS_FNAME and CUS_LNAME in…

A: The question is solved in step2

Q: Customers Customer ID Last Name C0001 Faulkner C0002 Wit Loan Id L0010 L0017 L0016 Customer Total…

A: CustomerID Last Name Loan ID Amount   C001 Faulkner L0010 200000       L0017 100000…

Q: You are given the following data tables: Employees(Employeel D, LastName, FirstName, BirthDate,…

A: In this question, we have been given the data tables and we have to write a query where to find all…

Q: Write three functions in SQL which does the following: The first function should take an integer…

A: In MYSQL function Syntax to convert number from one base to another follows:- CONV(<num to…

Q: Use the following table to find the OUTPUT of the following SQL queries: Table Name: Patients…

A: Answer: 98877445

Q: a) Find department_id for departments that do not contain the job id ST_CLERK a) lists the employee…

A: In this question we have to provide the SQL code for the following queries. Let's query and hope…

Q: Use the following table to find the OUTPUT of the following SQL queries: Table Name: Patients…

A: TO_CHAR function is used to typecast date input to character type with a format model. Syntax:…

Q: 9. Display student no, student name and leader name for all students including those without leader…

A: Since table name is not mentioned, I am assuming table name as Students

Q: obtain the name and credit limit of the customer whose number currently is stored in I_CUSTOMER_NUM.…

A: I have answered this question in step 2.

Q: Q3: How many unique titles do we have in the employee table? Hint: You need to create TWO queries,…

A: 1)   SELECT DISTINCT titles FROM EMPLOYEE

Q: In SQL Server, character data types may be distinguished as follows: NVARCHAR, NVARCHAR, and…

A: Introduction: A SQL developer must choose what information will be kept in each column before…

Q: Use the following table to find the OUTPUT of the following SQL queries: Table Name: Patients…

A:

Q: Use SQL Developer or Oracle Live SQL to write the appropriate SQL commands as follows: a) Group all…

A: Process To display the all the data we use select * from tablename and condition what we want to get…

Q: ROOMS RID RType Rate Bedroom Room_Status CID 101 Studio 10 1 Available   102 Studio…

A: SELECT  - It is used to query or retrieve data from a table in the database AS  - This command is…

Q: SELECT TO CHAR (DOB, ' DD/YY/MM') FROM patients WHERE Medical_no-1001;

A: Given query: SELECT TO_CHAR(DOB, 'DD/YY/MM') FROM patients WHERE Medical_no = 1001; Explanation The…

Q: Students Table : • List of all Students, just FirstName, LastName and gpa, with a C avg(2.0 to…

A: ANSWER: Student Table: Syntax of SQL Table Statement

Q: You are given the following data tables: Employees(Employeel D, LastName, FirstName, BirthDate,…

A: To find all orders where the shipper ID of the order is greater than or equal to 1000, we can use a…

Q: To locate NULL values, which operator should you use?

A: An operator is a special symbol in an SQL statements' WHERE clause which performs operations on…

Q: „By using SQL language return the items and their total number of units that have been ordered…

A: We have to pick the items where item name is not Pen and sum of Units of each Item category

Q: What is the function of a column qualifier? When do you have to use one?

A: Column qualifiers are used for distinct access of the data values in order to identify them…

Q: For every invoice, display the invoice number, invoice date and the total dollar amount for all…

A: Dear student  your query get the error because inv_number exist in the two table so you have to…

Q: Select clause: Display the columns stated in the problem statement  From clause: AUTHOR table…

A: SQL is a structured query language, that's is used to extract and manipulate the data from the…

Q: In Oracle PL/SQL programming language, %TYPE keyword would give you some advantages when you are…

A: Below are the advantages:

Q: C) Which employees earn less salary than the average salary for the consultants who perform the same…

A: According to the information given:- We have to consider the instruction to write queries on the…

Multiple Table

In a database, a table is used to store data in the form of rows and columns. Rows are aligned horizontally and identified by one or more values in a specific column. Columns are vertically aligned and identified by a unique column name.