Table :- EmpProjectEmpIdProjectld ClientIDProject nameStartYearEndYear101p-1Cl-1pharmacy20102010102р-2Cl-2textile20102012103р-1Cl-3travels2013104р-4Cl-1xerox20142015105p-4Cl-5cosmetics20156. List the number of department of employees in eachproject.7. How many project started in year 2010.8. How many project started and finished in the sameyear.9. select the name of the employee whose name's 3rdcharacter is 'h'.10. List all the values of project table in ascending orderof project name. Q1 : Table Name:- EmployeeEmpid EmpNameDepartmentContactNoEmailIdEmpHeadId Salary101AyeshaE-1011234567890isha@gmail.com1054000102PriyaE-1041234567890priya@yahoo.com1036000103NehaE-1011234567890neha@gmail.com1017000104RahulE-1021234567890rahul@yahoo.com1054000105AbhishekE-1011234567890abhishek@gmail.com 10250001. Select the detail of the employee whose name startwith A.2. Select the details of the employee who work either fordepartment E-104 or E-102.3. What is the department name for DeptID E-102?4. What is total salary that is paid to all employees?5. Select the detail of employee name and departmentwho is getting salary above 5000.

CREATE TABLE Employee( Empid int, EmpName varchar(255), Department varchar(255), ContactNo int,…

6. List the number of department of employees in each project. 7. How many project started in year 2010. 8. How many project started and finished in the same year. 9. select the name of the employee whose name's 3rd character is 'h'. 10. List all the values of project table in ascending order of project name.

6. List the number of department of employees in each project. 7. How many project started in year 2010. 8. How many project started and finished in the same year. 9. select the name of the employee whose name's 3rd character is 'h'. 10. List all the values of project table in ascending order of project name.

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Similar questions

Below are some rows of the PROVIDERS table for a factory: PCODE 10192 98411 0489035 NAME Hans, Inc. Tools and More Motors Inc. PHONE 231 - 3092 231-1029 993 - 1821 All providers from the factory zone of the city start with 231. You want to get the providers that are in the factory zone of the city. Which of the following is more appropriate? O a. O b. SELECT * FROM PROVIDERS WHERE PHONE LIKE '% 231' O C. O d. SELECT * FROM PROVIDERS WHERE PHONE LIKE $231%' SELECT * FROM PROVIDERS WHERE PHONE LIKE 231 SELECT * FROM PROVIDERS WHERE PHONE LIKE '%231%'
Task 14: List the invoice number and invoice date for each invoice that contains an invoice line for a Wild Bird Food (25 lb).
List the names of all Staff members who hold a faculty position and have a salary of $45,000 or less. Show their names as their first name, followed by a space, and then their last name but sort the list alphabetically by last name and then first name. Hint: Check out the Position column in the Staff table. All staff members who do not hold a faculty position will get a bonus this year equal to 5% of their salary. List the names, current salary, and bonus amount for each Staff member (non-faculty) who is due a bonus. Show your list in order with the person receiving the highest bonus first.
Create a report of employees within the Research department showing First Name, Last Name, sorted alphabetically A-Z.
Task 22: KimTay Pet Supplies is considering discounting the price of all items by 10 percent. List the item ID, description, price, and discounted price for all items. Use DISCOUNTED_PRICE as the name for the computed column.
WEEK 9 ASSIGNMENT#3 Part I: Complete the following exercise: Create the following table with the correct columns. Call your new table: student_course (see below). Populate this table with four rows. Make sure the student id column contains values that are also in the student id column of your student table. student id course id semester year Join the student and student_course table where the student id values are the same. Join the student and student_course table where the student id values are the same and year is equal to 2020. Create a select statement that will return the length of the last name column by joining the student and student_course table where the student id values are the same and enroll month is June. Once you have completed your assignment, copy and paste the script into a Word document. Part II: Complete the following exercise: Using a subquery, select student first name where the student is in the student course table. Using a subquery, select the…
Based on the ERD below, display the first name, last name and employee initial of anyone whose first name starts with “A”. (Hint: You will use a “Like” phrase.)
List the name of each department, and its total number of employees, and the total amount of salaries
Assume the EMPLOYEE table contains four attributes, ID, DEPT, SALARY and NAME, and has the following rows ID DEPT SALARY NAME 100 SALES 40000 Smith 101 RD 38000 Terry 102 HR 60000 David 103 SALES 58000 Ellie 104 RD 70000 Judy The DEPARTMENT table contains two attributes, DEPTNAME and PHONE, and has the following rows: DEPTNAME PHONE RD 8596001234 SALES 8596005555 HR 8596009876 A.) The EMPLOYEE table needs to enforce the following integrity constraints: • The ID is the primary key. • The DEPT column is a foreign key that references the DEPTNAME in the DEPARTMENT table, so that any value that appears in the DEPT column should also exist in the DEPARTMENT table. • The value for the NAME column can never be null. What should be the statement used to create the EMPLOYEE table, if 1) the table was created as a partitioned table such…
Based on the ERD below, display the first and last names, hire dates, and number of years employed for all employees who have worked for the organization more than 15 years. Order by the most recent hire date.