1. List the Customer Id, Last Name for all customers, sorted by Last Name, ID. Table "Customer Id" b. List the loan number and loan amount for all loans belonging to branch 3. c. List the loan number, loan amount from all branches with the branch name "DowntownGR" (use branch name, if you have a 1000 branches, you are not going to know the branch number for each branch name).

Q: 3. Modify the CUSTOMER table: a) to include the customer's date of birth (CUST_DOB), which should…

A: Actually, database is a used to stores the data.

Q: 5- Find Customer ID, Customer name and Customer City for all accounts, sorted by Customer City, then…

A: According to the Question below the solution:   As per our company guidelines we are supposed to…

Q: 6- Find Customer ID, Customer name and the number of loans for each Customer.

A: As per our guidelines we are supposed to answer only one question. Kindly repost the remaining…

Q: Write Queries for the following: a. List all student whose Surname begins with b or end with a or…

A: Question 3 is answered as per the guidelines, please repost other questions. The data inserted into…

Q: -v is the complete table of registration ciation allowed. Student Course Offering Student

A: Given:

Q: Student( Enrno, name, courseId, emailId, cellno) Course(courseId, course_nm, duration) i) Add a…

A: Q: As per bartleby policy, we can only answer 3 subparts per question. Please post rest of sub parts…

Q: Find the first names and last names of employees if they got a salary increase more than 10% in the…

A: create table commands and inserting sample data into the table for query  create table employees…

Q: Display a list of all book titles and the percentage of markup for each book. The percentage of…

A: ROUND function The ROUND function is defined as a numerical function in Oracle or SQL to round the…

Q: The Primary Key is (doctorID, patientID).   i. Explain why the above table is not in 2nd Normal…

A: Below is the answer with explanation:

Q: 1- List all the users and their card name using union 2- List all the users and their card name…

A: Answer1 :   We will need to join the multiple sets to get the required details So, we will join the…

Q: Write the following queries  (a) List the details of branches in a given city. (b) Identify the…

A: "Since you have asked multiple questions, we will solve the first three questions for you. If you…

Q: . Which manufacturers are located in the city of New York? Show the manufacturer's name, state,…

A: First, three parts will be answered. SQL query: 1) In this query, the SELECT statement along with…

Q: Print each employee, their wages, Hours and gross pay.

A: namesList=['Juan','Rae','Ivanna','Lilly','Robert'];         #list to store names…

Q: sql   In the orders table, group by ship_via, employee_id, ship_country fields, where the ship_via…

A: Given table name: orders Field names to display: count of the number of items as total and the…

Q: Based on table below, using oracle: used subqueries, display the name of supplier(s) that supplied…

A: MAX will fetch the maximum value in column

Q: 1. Use Employees table a) To display First_Name, Salary and Department_id ofall the employees, whose…

A: 1.   A)   select First_name, Salary, Department_idfrom Employeeswhere Department_id IN(50,80)…

Q: Based on table below, using oracle. used subqueries,display the name of supplier's that supplied…

A: Check for the supplier id's who supplied whose value is more than that of IBM computers  Then, you…

Q: Write the set of SQL commands necessary to insert the data into the CUSTOMER table you created in…

A: Insert Into is a kind of DML (data manipulation language) command used to added tuples (rows) into…

Q: Write correlated and noncorrelated subqueries and understand when to use each.

A: This question argues about correlated and noncorrelated subqueries and understand when to use each.

Q: Write a query to display the employee number, first name, last name, and largest salary amount for…

A: Actually, database is a used to stores the data.

Q: Write queries in SQL to answer each of the following questions:…

A: Below are the required queries: As per our company guidelines we are supposed to answer only first 3…

Q: 4. List all customers (last name, first name and zip code) whose zip code is missing (unknown). 5.…

A: According to the Question below the Complete Query:

Q: 1. List the item number, description, and price for all items. 2..List all rows and.columns. tor the…

A: Note : As per company guidelines, we are supposed to answer 3 sub - parts . Please repost other…

Q: Using the Employees table display the department_id and the average salary of all the employees for…

A: A query to calculate average and to retrieve columns from one or more tables is created using the…

Q: 3. Using the EMPLOYEE table that already exists, use a subquery to insert the remaining rows from…

A: Using the EMPLOYEE table that already exists, use a subquery to insert the remaining rows from the…

Q: The following table stores details of tutors, students and dates of lectures. The Primary Key is…

A: Rules regarding 2nd NF:-  tables must be in 1st NF.  No non-prime is functionally dependent on part…

Q: Why are subqueries used?

A: Given:   Why are subqueries used?

Q: What will be the output of the given queries on the given table shown below: Student(SID,…

A: Given Table: Student(SID, NAME,CLASS, SECTION) Requirement: Find the output when the following query…

Q: Show Student name, reg no, marks and grade from the table Student_info?

A: Algorithm :  Step 1 : creating the table Student_info using the information. Step 2 : inserting the…

Q: Which month and year (e.g., March 2017) had the greatest number of ER visits? • The result table…

A: To extract data from a database, the SELECT statement is used. The data is saved in a result table…

Q: Provide a summary of customer balance characteristics for customers who made purchases. Include the…

A: Actually the given information is Minimum Balance 0.00 Maximum Balance 345.86 Average Balance 70.30

Q: 5. Write a SQL query to find the maximum, minimum, and average salary of the employees. 6. Write an…

A: Given, Table EmployeeDetails: EmpId FullName ManagerId DateOfJoining City 121 John Snow 321…

Q: Product(pid, name, type, manufacturer, price) Buys(cid, pid) Customer(cid, cname, age, gender) Write…

A: SQL Query :  SELECT pid,manufacturer,MAX(price) AS MostExpensiveProductFROM ProductGROUP BY…

Q: Write the SQL code that will list only the distinct project numbers in the ASSIGNMENT table, sorted…

A: To solve the question - Step 1: Let us first create a table named "ASSIGNMENT" with columns as…

Q: Write SQL Query that display department id and department name that employs fewer than five…

A: Given: Write SQL Query that display department id and department name that employs fewer than five…

Q: es in relational algebra. Find the username of users who are from ‘Muscat’. Find the IDs of pictures…

A: 1. Find the username of users who are from ‘Muscat’ SELECT username FROM users where place='Muscat'…

Q: Question 2: SQL Please see the following tables. Solve the questions with nested queries and…

A: SELECT Sailors.rating, AVG(Sailors.age) AS average_age FROM Sailors GROUP BY Sailors.rating HAVING…

Q: Question 2: SQL Please see the following tables. Solve the questions with nested queries and…

A: select avg(age),rating from sailors group by rating having count(*) >= 2

Q: Display customer ID, customer name, and the order ID and the order date of all orders for customer…

A: 1- In this assignment requires, select, where clause, aggregate function, group by, and order by.…

Q: Consider the following table: Instructor (Instructor_Id, Instructor_Name, specialization, Address,…

A: The syntax for writing the PL/SQL function is-  CREATE  [OR REPLACE] FUNCTION function_name…

Q: Employees(employee_id, first_name, last_name, salary, hire_date, job_title, manager_id) Which of the…

A: query that will is: select e.last_name from employees e, employees m where e.manager_id =…

Q: Write the SQL queries for the following questions and show results. List all the section numbers of…

A: In the structured query language, the query consists of the three clauses that are used to retrieve…

Q: 15. List the first name for all contacts and whether they have a spouse or not (yes/no). Order by…

A: Structured Query Language : SQL ( Structured Query Language) is an area explicit language utilized…

Q: 1. Show Student name, reg no, marks and grade from the table Student_info?

A: Note: There are multiple questions are given in one question. According to the rule, you will get…

Q: Question:1 Show all data from employee table where name should be in ascending and salary in…

A: NOTE: We’ll answer the first question since the exact one wasn’t specified. Please submit a new…

Q: Implemet the following Query on the books table from book store database. Note: the table books…

A: We use the create table command for this. This is DDL command and we don't require commit command…

Q: C. Write the following queries to retrieve the information detailed below. Average number of…

A: As per the guidelines we have given answer for the first three subparts of your question. the…

Q: Write SQL queries for the following.Display details of those male patients whose age is 25 or 36.…

A: Structured Query Language is abbreviated as SQL or also pronounced as See-Qwell. It is developed for…

Q: What is the use of sub queries?

A: Introduction; Anywhere an expression is permitted, a subquery may be utilized. In this case, the…

Q: What is the use of sub queries?

A: Sub queries are the inner queries written inside a SQL query. these are kept inside WHERE clause.