EMP: NUMBER (4) EMPNO VARCHAR2 (10) ΕΝΑΜΕ VARCHAR2 (9) JOB NUMBER (4) MGR HIREDATE DATE NUMBER (7, 2) SAL NUMBER (7, 2) СOMM NUMBER (2) DE PTNΟ DEPT: NUMBER (2) DE PTNΟ VARCHAR2 (14) DNAME VARCHAR2 (13) LOC

Q: CONCAT the patients’ first and last name and display their DOB in the following format ‘DD, Month…

A: According to a question we need to CONCAT the patients’ first and last name and display their DOB in…

Q: Draw flow chart to estimated salary for the proportion of workers 6 people 5 ID per hour where…

A: 1) For start and stop we have to use oval symbol  2)For calculation we have to use rectangle  3)For…

Q: Using the Bowlers and Bowler_Scores tables, list the BowlerID, bowler name, and raw score for each…

A: The given problem requires us to find the BowlerID, bowler name, and raw score for each bowler who…

Q: Use the following tables to write the SQL queries: Table Name: Employees EMPLOVE FRST NAME HDATE…

A: LIKE operator in MySQL is used when column entries needs to be compared as per a given pattern.

Q: List the years and their total gross earnings (sum of earnings per year), but do not include gross…

A: ANSWER:-

Q: Write SQL query to find total number of students in table : Class11(RollNo.,Name, Section, Marks)

A: Given Table: Class11(RollNo.,Name, Section, Marks) To Find: Total number of students in table.…

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: Calculate the number of days that have passed between your birthday and the current date using an…

A: Given:   Calculate the number of days that have passed between your birthday and the current date…

Q: Find the numbers that has not been used as DEPTNO in the DEPT table.

A: you can use this query

Q: Write SQL Command to display employee first name , department name and the county id.

A: i have provided answer in step2.

Q: how to calculate and display the total charges of all outpatients in the month of October 2018

A: Language is one of the most widely used programming language which has been used to create different…

Q: Find the minimum number of students needed to guarantee that 11 of them were born in the same month.

A: Answer to the above question is in step2.

Q: what is the sql query needed to get total number of beers?

A: SQL (Structured Query Language) is a standardized programming language that is used to oversee…

Q: - Copy the name, salary, and commission of each employee hired before 1980 into TEMP table - Copy…

A: INSERT INTO query is used to copy the sql data from one table to another table.WHERE is SQL clause…

Q: complete the income statement for Thom-Pierre consultants for the  year ended 31 december.…

A: total expenses bedpre taxes= 460000+195000+55000+25200=735200 Total taxeble income=  2073500-735200=…

Q: If every student at a school is assigned a 4-digit person ID number, but 0 and 1 are not used in ID…

A: The question asks about the potential number of student ID numbers in a school where each student is…

Q: ? List each order number and the date it shipped. SQL comm

A: Solution - In the given question, we have to write the SQL command for the given query.

Q: Using database, show the first name and birthday for all female staff whose birthday is before…

A: Introduction: The AND, OR, and NOT operators can be used with the WHERE clause. Records can be…

Q: Show the employee dataframe after sorting by year join in descending order and by salary in…

A: Using R show the employee dataframe after sorting by year join in descending order and by salary in…

Q: Given the employees of medium-sized semi-conductor firm, find the employee that joined November 8,…

A: The Excel INDEX function returns a value in an array based on the row and column numbers you…

Q: Show students’ first name and last name, the course numbers the student took (don’t include…

A: Data is coming from 3 tables . So apply inner join on 3 tables with joining condition.  student…

Q: all the related employee attributes for those employees whose salary is above 5000

A: all the related employee attributes for those employees whose salary is above 5000

Q: List the department name and its instructor’s average salary in which the instructors teach a course…

A: SQL implements WHERE clause with SELECT command in order to retrieve stored information from the…

Q: normalize this table to 3NF

A: If there is no transitive dependency for non-prime attributes, then the relation must be in third…

Q: Write an appropriate SQL query to determine which student is registered for the most credits (total…

A: In this question we have to write a sql query for given statement and table. Let's complete the sql…

Q: Please explain how to set the mining “difficulty”.

A: The difficulties of mining association rules from large databases: 1. Security and social issues:…

Q: write a SQL query to find fifth maximum salary from table Employee (EID, EName, Salary)

A: To Find the 5th maximum salary we will use subqueries or co-related queries.  In the  inner query we…

Q: the numbers of employees hired in different companies are 36 60 71 91 16…

A: Given data set, The  numbers of employees  hired in different  companies  are :  36  60   71   91…

Q: Write SQL query to increment SALARY of all employees by 100 whose current SALARY is 1000 in the…

A: The SQL UPDATE statement modifies the data of one or more records in the table. All rows can be…

Q: Write SQL Command to display all employees details whose job id is either AD_VP or PU_MAN. Order the…

A: We are given Employess table which contain all the attributes asked in query, so we will use…

Q: What Is The least squares estimates?

A: Least squares method This technique was first developed by the German mathematician, Carl Friedrich…

Q: esperson ID Name Salary Com_Rate Hire date 1 John 100000 2 Amy 120000 3 Mark | 65000 4 Pam 5 Alex…

A: SQL commands are instructions. It is used to communicate with the database. It is also used to…

Q: Table : PURCHASE_ORDER ORDER_NO AMOUNT ORDER DATE CUSTOMER_ID SALESMAN ID DELIVERY_ DATE 1001 300…

A: b) SELECT * FROM PURCHASE_ORDER INNER JOIN PURCHASE_DETAILS ON PURCHASE_ORDER.ORDER_NO =…

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…

Q: balance that exceeds their credit limit?

A: How many customers have a balance that exceeds their credit limit? Below is the query :

Q: Find the total revenue generated by each product in the past quarter (last 3 months), you would need…

A: In SQL Server, we can use the DATEADD() function to get last 3 months (or n months) records.

Q: For each product, show the product ID and the number of orders placed. Show the results in…

A: Introduction: SQL (Structured Query Language) is a database computer language designed primarily for…

Q: From worksheet Product, in cell 15, display the week number of the date given in cell 19. Answer:

A: Given: Calculate week number for excel.

Q: Display details of jobs where the minimum salary is greater than 10000. using sql plus

A: SQL Query: Assume a database JOBS which has Columns JOB_ID, JOB_TITLE, MIN_SALARY, MAX_SALARY. Now,…

Q: List the names of all Staff members who hold a faculty position and have a salary of $45,000 or…

A: SQL Space: To leave the space while displaying the data ,a function called space is used. Syntax:…

Q: 1.Write SQL Command to, display employee id and ob id who gets salary within the range of 4000 and…

A: SELECT keyword is used to display particular columns  BETWEEN is the keyword used to specify the…

Q: Find employees who are making less than the average of the employees hired in the same year using…

A: SELECT ENAME FROM employees WHERE salary < (SELECT AVG (salary) FROM employees )

Basic SQL Queries

Structured Query Language is the full form of SQL. It is a high-level language used to communicate with a relational database. It is used for creating, storing and accessing contents of a relational database. SQL is used to write the queries which are executed using database engines like Oracle, SQL Server and so forth.