b. Write SQL queries for the following statements.i. Display all the employee's details in the decreasing order of their salary.II. Count and display the number of employees worked in each project.ii. Add the given new department's data into the Department table.deptidDept_name123Human ResourcesParagraphv 3 (12pt)ArialO Mashupahere to search

As the data is not provided, I used the dummy data, and queries are solved using the MySQL database.…

b. Write SQL. queries for the following staterments. i Display all the employee's details in the decreasing order of their salary. . Count and display the number of employees worked in each project. . Add the given new department's data into the Department table. deptid Dept_name Human Resources 123 Paragraph Arial Mash

b. Write SQL. queries for the following staterments. i Display all the employee's details in the decreasing order of their salary. . Count and display the number of employees worked in each project. . Add the given new department's data into the Department table. deptid Dept_name Human Resources 123 Paragraph Arial Mash

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

You are given the following schema of a University, where primary keys of each table are underlined and symbol (#) symbolises foreign keys: Student (student id, first_name, last_name, date_of_birth) Course (course_id, #professor_id, course_name, credits, programme) Exam (#student id, #course id, exam_date, grade) Professor (professor id, first_name, last_name, research_field)
Given the table PRODUCT(ProductID, ProductName, ProductClass, ProductWeight, ProductStyle, ProductColor, ProductPrice). Note: ProductWeight and ProductPrice are numeric fields, and the other attributes are character fields, i.e., store text. Write a SQL query to display the product class whose average price is at least 50
Write in SQL
Thank you for helping! Write the SQL code to produce the total number of hours and charges for each of the projects represented in the ASSIGNMENT table. The result is shown as below. Write the SQL code to display the information of employees who are working as either programmer or system analyst. Write the SQL code to produce job_descriptions(job_title) of employees who are working at project ‘Evergreen’.
1. Find out each manager's work address. Note that a manager's work address is the same as the address of the department which s/he manages. • Address Format: Street_AddressPostal_Code CityCountry_Name • Write query in oracle sql.
Use the Pine Valley Furniture (PVF) database for this question. Write a SQL query to display the customer ID and total number of orders placed for those customers who placed more than one order.
use sql to answer the following question To perform below tasks, refer to tables in the JustLee Book database. Create a list that display the title of each book and the name and phone number of the contact at the publisher’s office for reordering each book. Which books were written by an author with the Last Name-First Name (BAKER JACK)? Perform the search using author’s last name/first name. Determine which book(s) purchased by customer Steve Schell. Perform the search using the customer name & last name, not the customer number. If he/she has purchased multiple copies of the same book, unduplicated(DISCTINC) the result.
use sql to answer the following question an erd had been provide List all police officers who are assigned to the precinct OCVW or GHNT and have a status of active. List the officer ID, last name, precinct, and status. Sort the list by precinct and then by officer last name.
use sql to answer the following question an erd has been provide List all criminals along with crime status and appeal status (if applicable). The reports need to include the criminal ID, name, crime classification, date charged, appeal filing date, and appeal status. Show all criminals, regardless of whether they have filed an appeal. Hint: Join between tables criminals, crimes , appeals Inner join between criminals and crimes but LEFT JOIN with appeals
Consider this table. The table name is Employees. Sql