1A.) USE Bobs_Home_Repairs     SELECT CUSTOMER.First_Name ,CUSTOMER.Last_Name   FROM EMPLOYEE_JOBS LEFT JOIN dbo.CUSTOMER ON CUSTOMER.Customer_ID = EMPLOYEE_JOBS.Customer_ID   WHERE DATEPART(MONTH,EMPLOYEE_JOBS.Date_Estimate_Sent) = DATEPART(MONTH,GETDATE()) what am i doing wrong. none of my data will print

Q: The query that displays names of employees , sex , and evaluation of the salary for each department…

A: SELECT AVG(salary) /*incorrect*/ FROM EMPLOYEE, DEPENDENT  /* a salary is included once */ WHERE…

Q: Create a SQL query that pulls OrderID and OrderDate from the Orders database, as well as…

A: Definition A JOIN clause is used to merge data from more than "2" tables based on a common column…

Q: To create a table name Customer having fields Cust-name, Cust_address from the table Employee and…

A: Answer: Introduction: SQL stands for Structured Query Language, one of the most common commands. It…

Q: Given the schema: department(department_id, department_name) employees (employee_id, first_name,…

A: Given the Schema we have to write SQL query.

Q: Q-1. Write an SQL query to read "FIRST NAME" from Worker table using the alias name as WORKER_NAME.…

A: Actually, SQL structured Query Language.

Q: Note that primary keys are in BOLD. Note also that attributes with the same name in different tables…

A: Here have to determine about SQL statement of given problem statement.

Q: based on the information below create a oracle SQL table and insert some values into each table.…

A: CREATE TABLE Publisher (name varchar2(20) NOT NULL, phone number(10) NOT NULL, city varchar2(15)…

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

A: Since you have not provided the database name to write the SQL query so I am using MySQL database to…

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

A: 5. calculate the percentage of any student and round to 0 digit SELECT cast(round((457/500) *100),0)…

Q: Prescription is in 2NF. Is table Prescription in 3NF, given the dependencies? If yes, why? If not,…

A: Data Structure Software: Tools are necessary to eliminate excess and inconsistencies, preserve…

Q: 3. How many syntax errors in the following code? * proc sql; select count(Supplier_Name) 'Low Volume…

A: There were 4 syntax errors in the code given in the question. They are rectified using bold. The…

Q: Consider the below Student table and write the appropriate relational algebra query: City SNAME…

A: Relational Algebra: It is a procedural query language that takes relation instance as input and…

Q: Create the following table in sqlplus through query? Student_info Reg_no Nicno Name Address…

A: NOTE: Since we only answer up to 3 sub-parts, we’ll answer the first 3. Please resubmit the question…

Q: Q2/ The difference between the results of executing the following two SQL commands: delete from…

A: Answer to the given question: delete from Employee: will delete all the tuples from the Employee…

Q: What is the SQL command to list the total sales by customer and by product, with subtotals by…

A: The SQL query to list the total sales by customer and by product is as follows. SELECT CUS_CODE,…

Q: Note that primary keys are in BOLD. Note also that attributes with the same name in different tables…

A: Solution:   2.3)   Treatment table before increment by 2.5 % in costOfTreatment :

Q: Given the following table TABLE CUSTOMER Column Null? Туре CUS_ID NOT NULL NUMBER NAME VARCHAR2(50)…

A: In SQL, the SELECT statement can be applied to fetch records from any relation. It can display…

Q: Please use Pl/sql ro answer the following question, and red had been provide First create below…

A: Below is the PLSQL code to create table and insert records as per given in question:

Q: The following is the script for the SQL: set sql_safe_updates=0; drop table if exists message;…

A: Hi  We have ran the below scripts and mentioned the results as well. drop table message;  --…

Q: 2- selects the order line items (orderNumber, orderlinenumber) from the “orderdetails” table. Also,…

A: According to our guidelines, we are allowed to solve only the first three subparts of the question.…

Q: Write a query to display the record of the person living in Rawalpindi and Karachi? Write a query to…

A: SQL syntax to create a table:   Create table tableName(columnName1 dataType, columnName2 dataType,…

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

A: 1)Show all data from employee table where name should be in ascending and salary in descending…

Q: SELECT BRAND_NAME, BRAND_TYPE, round(AVERAGE,2) AS 'Average Price', UnitsSold FROM (LGBRAND INNER…

A: Actually, SQL stands for structured query language.

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

A: Question 1 Ans : SELECT * FROM employee e  ORDER BY e.name ASC, e.salary DESC; Question 2 Ans :…

Q: Can you write 10 query for this tables? Plase use join and nested queries Customer…

A: I give 10 queries

Q: 3) Write an SQL query to display the accountno, name, Recurrent_acno, transaction_date whose Eixed…

A: NOTE Below is the answer for the given question. Hope you understand it well. If you have any…

Q: 4. Consider the follwing Customers table CREATE TABLE Customers ( Customer_ID INT NOT NULL PRIMARY…

A: DELETE Syntax DELETE FROM table_name WHERE condition;

Q: By using oracle Sequence, you can generate a numeric value that can be assigned to any column in any…

A: I have given an answer in step 2.

Q: Refer the given table and answer the question that follow: TABLE : CLIENT Client no Client_Name…

A: Given, Two tables: Client Client_details

Q: Which of the following functional dependencies does NOT exist in the table ENROLLMENT? ENROLLMENT…

A: Functional dependency: ==> Functional Dependency (FD) is a constraint that determines the…

Q: Prompt: You work in the Procurement Department, and you need a list of select items carried for sale…

A: I have solve the SQL query below see it ... SQL statement::  SELECT Product.ProdName,…

Q: Cities having Summer Temperature More than Jaipur *Only SQL code needed* Write a query to display…

A: As per given problem we have to develop a SQL query to display all the town names which has summer…

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: Suppose you wish to see the employee name and salaries of the employees whose salary is greater than…

A: Here have to determine correct option for given sql query problem.

Q: I need sample SQL scripts that will insert the data to the database (at least one row in each table-…

A: Model and a couple of general considerations

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

A: As per Bartleby's answering guidelines if there are multiple questions then only the first three…

Q: 2 Write a SQL Command to Insert the records in the following tables CUSTOMER88 TABLE: CUST ID CUST…

A: INSERT INTO CUSTOMER88 VALUES(80001,"SUHAIL","HEADACHE","13-JAN-2018",250.000,93523655);INSERT INTO…

Q: Write a query to find, name, hire_date, phone_number, department name for the employees in HR…

A: oehr_departments and oehr_employees are connected by department_id and manager_id in both the tables…

Q: You have been asked to run a query using the CASE statement to analyze the quantity of shares data…

A: Attached Oracle Query below: select sum(B1) as "0-100", sum(B2) as "101-400", sum(B3) as "401-800",…

Q: What results will the SQL queries below return? If there are errors in the queries, indicate what…

A: Query 1: Select * From Where Department.id = 1 Query 1 throws error because no table name is given,…

Q: Examine the table structure as given. SOL» DESC employees Name Null? Type - EMPLOYEE_ID NOT NULL…

A: The answer is

Q: What are the customer IDs and names of all customers, along with the order IDs for all the orders…

A: SQL (Structured Query Language) is designed primarily for managing data in a relational database…

Q: Report all books published after Jan. 1st, 2015, as well as all books published in 2014 that have…

A: SQL query will be: SELECT TITLE, PubID, RETAIL, PubDate FROM BOOKS WHERE (RETAIL<= 50 AND YEAR…

Q: Please match the keyword or operator from the list below to its correct SQL explanation and syntax…

A: The ? has been replaced in the below table.

Q: Write SQL commands for following customer table: CustomerID Cust_Name Age Address Order_amount 101…

A: 1. Write a query to create a customer table containing above columns, whereas customer id as primary…

Q: The query that will show the customer records sorted according to region_id SELECT * FROM customer…

A: The correct option is  c) SELECT * FROM customer ORDER BY region_id

Q: Apply inner join and full join between two tables and show intersection and union of contacts and…

A: The requirement is to create two tables in SQL, the insert atleast 10 records in each table. The…

Q: Questions: Q-1. Write an SQL query to read "FIRST NAME" from Worker table using the alias name as…

A: Please give positive ratings for my efforts. Thanks.   As per guidelines, we are allowed to answer…

Q: LAB 2: SUBTASK 1: Fill in the following tables: as preliminary lab work (some are filled for your…

A: Column Name Primary Key  Foreign key  Data Type Nullable default sample Entry address_id v…

SQL Query

Structured Query Language is the full form of SQL. It is one of the standard languages to deal with the relational database. It is used to insert, update, delete, and search the records stored in a RDBMS. The relational databases are created and managed by using SQL.