Make a list of salespeople who made no sales on a Monday (Hint: your answer to question 1 is a good starting point).

Q: Find the first names and last names of employees if they got a salary increase more

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

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: Make a list of customers with the list of orders and the amount of dollars that they paid for each…

A: Queries are used to fetch the data from database. Normally SELECT,FROM,WHERE keywords are used to…

Q: Make a list of authors and books they wrote, using book ISBN number only, sort by author# or…

A: Consider two tables :- Books with attributes (ISBN, booktitle, authorID) and Authors (authorID,…

Q: Make a list of authors and books they wrote, using book ISBN number only, sort by author# or…

A: Consider two tables :- Books with attributes (ISBN, booktitle, authorID) and Authors (authorID,…

Q: Make a list of authors and books they wrote, using book ISBN number only, sort by author# or…

A: Consider two tables :- Books with attributes (ISBN, booktitle, authorID) and Authors (authorID,…

Q: Make a list of authors and books they wrote, using book ISBN number only, sort by author# or…

A: Consider two tables :- Books with attributes (ISBN, booktitle, authorID) and Authors (authorID,…

Q: Determine which categories are represented in the current book inventory. List each category only…

A: The DISTINCT clause is utilized to remove duplicate records from the result set.  Syntax: SELECT…

Q: The foreign key in the table adult is called a foreign key.

A: Referential Foreign Key

Q: Delete the salesman who has the highest salary among all salesmen

A: SQL code for creating the table: /*creating table emp*/ create table EMP(     EMPNO number(4)…

Q: Show the list of courses numbers that are taken at least once by students. The course should appear…

A: So, all the unique course numbers has to be printed So, for this you can make use of DISTINCT…

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: Create a list that shows each department name, # of employees, maximum salary, minimum salary, total…

A: First EMP and DEPT tables have to join basing deptno in both.  Then group them by using dname. Then…

Q: Define users, giving the three groups of users there are.

A: Users A user is a person who utilizes a computer or network service. It includes expert programmer…

Q: SQL compile a list of all orders placed on day X by calculating the total number of repairs and the…

A: Solution:   Note :  You didn't mention the table schema so assume by myself.   Given,

Q: List the top-3 states that have the most number of employees. Show the state and the number of…

A: List the top-3 states that have the most number of employees. Show the state and the number of…

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: Add the following values in the table Doctor id Doctor_name Degree Join_year Salary D550 Saleh…

A: To insert data into table,  use syntax:-  insert into tableName values(data1,data2.........);   To…

Q: Change the bedrooms value in the LARGE_PROPERTY table to null.

A: UPDATE statement is used to update the data. Syntax: UPDATE TABLE_NAME SET COLUMN_NAME=VALUE WHERE…

Q: 6.2 List, in alphabetical order, the names of all patients who had consultations after 01 January…

A: Given: Converting ERD to relational schema The database will need to create below tables:…

Q: How many times has each book title been borrowed? Give the new column an alias.

A: Hey there, I am writing the required solution based on the above given question. Please do find the…

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: List all the rows in which the prescription dates occur on or after November 14. How many doctors…

A: The given assignment has required tables and data already inserted in it. The requirement is to…

Q: Run a query that reports back the average of each exam in the same query.

A: The following query will return the average of each exam- exam1, exam2 and exam3 in the same query:…

Q: Q. A table is a collection of related ______________ and it consists of _________ and _____.

A: Q. A table is a collection of related ______________ and it consists of _________ and _____.

Q: Write SQLSQL statements for following: Student( Enrno, name, courseId, emailId, cellno)…

A: We need to create tables for Student and Course And we need to insert values into these tables.…

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

A: Find the output of the given SQL query after the execution on the given table Student(SID, NAME,…

Q: What is the average cost of all emergency room visits for female patients? Name the computed column…

A: First we have to take PatientID from patient.csv whose gender is female. SELECT PatientID FROM…

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: i) Add a column city in student table. ii) Find out list of students who have enrolled in “computer”…

A: As per our company guidelines, we are supposed to answer only three subparts of post and kindly…

Q: List all customers who are either from New York or had a grade above 100.

A: SELECT CUST_NAME FROM CUSTOMER WHERE CITY='NEW YORK' OR GRADE>100;

Q: Add the following values in the table Doctor id Doctor_name Degree Join_year Salary D550 Saleh…

A: DOCTOR TABLE: CREATE TABLE DOCTOR(Docotr_id varchar2(5),Doctor_name varchar2(25),Degree…

Q: Recite the rule about columns in SELECT when a GROUP BY clause is used.

A: As per the bned policy we are supposed to answer only one question at a time. As the question is not…

Q: Q1- List all employees whose job_id is IT_PROG and hired after 01-JAN-95 and earning more than 5000.…

A: Let the table name be emp which has the following columns   employee_id, first_name, last_name,…

Q: Task 3: List the customer ID, first and last names, and balance for all customers. The balance…

A: round()- used to round the values to the nearest integer

Q: Return the name of the most expensive item in price_list. If there is a tie for the most expensive…

A: Kindly indent the code as shown in the screenshot below :

Q: f item price*item quantity is a computed field in Oracle, how does it compare to the table field?

A: In oracle we assume a database and fields. below we write a code to compare it with screenshot.…

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

A: Assume that the table name as "Person". SQL code to create the given table is as follows, create…

Q: If item price*item quantity is a computed field in Oracle, how does it compare to the table field?

A: Suppose an item has the exact effective dates on both the primary and secondary price lists. The…

Q: If item price*item quantity is a computed field in Oracle, how does it compare to the table field?

A: Here  we assume a database which have number of columns name like: so we write code to compare both…

Q: If item price*item quantity is a computed field in Oracle, how does it compare to the table field?

A: Item Quantity is a variable that increases the likelihood of monster loot drops. It is split into…

Q: Write SQL statements for the following queries: Retrieve First_Name , Salary, department Name and…

A: Retrieve First_Name , Salary, department Name and Location_Name  for all employees sorted by…

Q: A Column spanner in a table should describe which of the following

A: Lets see the solution.

Q: You have a table Employee(empID,name,salary,dno). Dno is department number to which employee…

A: Algorithm :  Step 1 : select the sum of salaries payed for the employees department wise.

Q: Use the table below to find the output PRODUCT ID PRODUCT NAME BRAND UNIT PRICE SUPPLIER ID CATEGORY…

A: Required:

Q: In order to figure out how many days have passed since your birthday and the current date, you need…

A: Answer: I have given answered in the brief explanation

Q: Create another table named students_dummy with exact data from students table.

A: A table in MySql contains data in row and column manner. A table can be created using the Create…

Q: Write down a sql query to find out "Firstname" (s) those have "s" letter in it and have monthly…

A: like operator is used to find pattern within string in SQL. Not more than 50000 is equivalent to…

Q: after revisiting the last table, which taks should we assign to John?

A: we solve the question here line by line with simple explanation:

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…