7. Display the name and hire date of even- employee who was hired in 1982. ENAME HIREDATE SCOTT 09-DEC-82 MILLER 23-JAN-82 8. Display the name and job title of all employees who do not have a manager. ENAME JOB KING PRESIDENT 9. Display the name, salary, and commission for all employees who earn commissions. Sort data in descending order of salary and commissions. ΕΝΑΜΕ SAL COMM ALLEN 1600 300" TURNER 1500 MARTIN 1250 1400

7. Display the name and hire date of even- employee who was hired in 1982. ENAME HIREDATE SCOTT 09-DEC-82 MILLER 23-JAN-82 8. Display the name and job title of all employees who do not have a manager. ENAME JOB KING PRESIDENT 9. Display the name, salary, and commission for all employees who earn commissions. Sort data in descending order of salary and commissions. ΕΝΑΜΕ SAL COMM ALLEN 1600 300" TURNER 1500 MARTIN 1250 1400

Programming Logic & Design Comprehensive

9th Edition

ISBN:9781337669405

Author:FARRELL

Publisher:FARRELL

Chapter8: Advanced Data Handling Concepts

Section: Chapter Questions

Problem 1RQ

See similar textbooks

Similar questions

Attempt to view the structure of the HOMEWORK13 view.
C sharp Table: Student (the headers are the field names in the Students table) StudentID Name Age Gender ProgramID 791 Stephanie Brown 19 Female BCS 236 Shannon Dawn 25 Female BA 618 Geoff Berg 24 Male ARET 256 Andrew Schilling 22 Male BSC 902 Gary Sang 23 Male DAAD Note: There is a StudentDataSet with a Student table, a StudentTableAdapter, a StudentBindingSource, and a StudentDataGridView control on the form.Note: There is an Average query, named Average, that returns the average age of the student from the Student table.Note: There is also Max query, named Highest, that returns the highest age of the student from the Student table.Write the code you would place in the AverageButton click event on your form to call the Average query and the Highest query and display in a DifferenceLabel, the difference between the highest age of a student and the average age.
PATHS is a table that contains information about paths on a number line. The structure of PATHS is as follows, where x1 and x2 represent that there is a path from Coordinate x1 to Coordinate x2 (You can't move from Coordinate x2 to Coordinate x1 ). NAME ΤΥΡE NULLABLE X1 INT FALSE X2 INT FALSE Problem Please write an SQL statement that returns the beginning and end point of each path in PATHS . Sort them by the value of the beginning point in ascending order. Constraints • In the case where a direct path from Coordinate a to Coordinate b is available, no path from Coordinate b to Coordinate a will be given. |x1-x2| = 1 • No path will overlap with one another. Example Suppose that PATHS is as follows: x1 x2 1 2 2 3 4 7 7 6 This table can be visualized as follows: START END END START 7 8. 9 Therefore, your SQL statement must return the following: start end 1 4 8 6
The table below lists customer/car hire data. Each customer may hire cars from various outlets. A car is registered at a particular outlet and can be hired out to a customer on a given date. carReg make model custNo custName hireDate outletNo outletLoc M565 OGD Ford Escort C100 Smith, J 14/5/98 01 Bearsden M565 0GD Ford Escort C201 Hen, P 15/5/98 01 Bearsden N734 TPR Nissan Sunny C100 Smith, J 16/5/98 01 Bearsden M134 BRP Ford Escort C313 Blatt, O 14/5/98 02 Kelvinbridge M134 BRP Ford Escort C100 Smith, J 20/5/98 02 Kelvinbridge M611 OPQ Nissan Sunny C295 Pen, T 20/5/98 02 Kelvinbridge The table shown above is susceptible to update anomalies. Provide examples of how insertion, deletion, and modification anomalies could occur on this table.
Description The Employee table holds all employees including their managers. Every employee has an Id, and there is also a column for the manager Id. +--- | Id | Name | Salary | ManagerId | +---- | 1 | 2 | 3 | 4 +---- | Joe | 70000 | 3 | Henry | 80000 | 4 | Sam | Max Given the Employee table, write a SQL query that finds out employees who earn more than their managers. For the above table, Joe is the only employee who earns more than his manager. + | Employee | + | Joe + | 60000 | NULL | 90000 | NULL I
5. In the OrderItems table, display a count of the number of products where item_price is greater than or equal to $6, grouped by prod_id, but only for those groups having 3 or more of a given prod_id. Display the count with the alias shown. Sort by prod_id in ascending order. BRO3 1 rows returned in 0.03 seconds PROD ID Download 4 NUM PROD ID
Q9) find the least expensive priceQ10) List the UNIQUE v_code of vendors that provide productsQ11) find the most expensive priceQ12) List the number of products by vendor with the average price, include only the rows withaverage price below 10.00Q13) List all vendor rows (including the ones that have no matching products) and all matchingproduct rows
Q1- List all employees whose job_id is IT_PROG and hired after 01-JAN-95 and earning more than5000.Q2- List all employee except those with employee_id 101, 102, 103, 104 and 105Q3- Display the city attribute from locations table. Show the ones that contain “South” in the city.Sort the list in descending order.Q4- Display the first name, last name, salary, manager id and job id of all employees whose last fourcharacters of job id ends with “LERK”.Q5- Display the first name, last name and salary of all employees. Round the salary to the nearestunit of 1000 (ex. Salary=4500 New Salary=5000). Label the column as "New Salary".
Having this information. StudentsAttribute Name Data TypeStudentID char(11)FirstName varchar(20)LastName varchar(20)Gender char(1)DateofBirth date CoursesAttribute Name Data TypeCourseCode varchar(6)CourseName varchar(70)Level char(2)Credits int RegistrationAttribute Name Data TypeStudentID char(11)CourseCode varchar(6)Grade decimal(2, 1) Write SQL code to: 1. What are the student ID, the names, and birthday of the female students who were born before the last day of 1992? 2. How many students are registered in the course “PHY210”? 3. How many courses are offered by the department of Computer Science (i.e. course codes CS***)? 4. Which course(s) (couseCode and courseName) of level G1 give 5 credits?
Having this information. StudentsAttribute Name Data TypeStudentID char(11)FirstName varchar(20)LastName varchar(20)Gender char(1)DateofBirth date CoursesAttribute Name Data TypeCourseCode varchar(6)CourseName varchar(70)Level char(2)Credits int RegistrationAttribute Name Data TypeStudentID char(11)CourseCode varchar(6)Grade decimal(2, 1) Write SQL code to: 1. How many courses are there on each level? 2. What is the average grade of courses that have been taken by the student with student ID 861103-2438? 3. Which students (studentID only) have the highest grade for the course ‘CS052’? 4. Find the courses (course codes only) that have been taken by both the student 861103-2438 and the student 123456-0980.
Add the following values in the table Doctor id Doctor_name Degree Join_year Salary D550 Saleh Khalil DM 2001 1700 D551 Osama Ahmad DPM 2011 2100 D552 Sarah Qasim B.Med 2013 1500 D553 Zuhair Mohammad DOM 2008 1600 D554 Amera Jalal MBBS 2006 1000 2.Show the doctor names that end with the letter D
3. In the OrderItems table, display a count of the number of products, grouped by prod_id. Display the count with the alias shown. Sort by prod_id in ascending order. BNBG01 BNBG02 BNBG03 BRO1 BRO2 BRO3 RGANO1 7 rows returned in 0.01 seconds PROD_ID Download 3 3 3 2 1 4 2 NUM_PROD_ID