xi) Display name, department and date of birth of those employees whose date of birth is before a particular date. Create a database in your name and do the following. 1. Create table MyFriends (Friend Id int), (Name varchar(20)),(Age int), (Salary dec(9,2)),(D_birth date). Enter 10 records. (i) Display all rows. (ii) Insert a new column place(varchar) Supply values for the newly added column and Display all rows. Display Sum, maximum, minimum and average values of salary. Delete rows where place contains the letter 'M' and display the remaining rows. (iv)
xi) Display name, department and date of birth of those employees whose date of birth is before a particular date. Create a database in your name and do the following. 1. Create table MyFriends (Friend Id int), (Name varchar(20)),(Age int), (Salary dec(9,2)),(D_birth date). Enter 10 records. (i) Display all rows. (ii) Insert a new column place(varchar) Supply values for the newly added column and Display all rows. Display Sum, maximum, minimum and average values of salary. Delete rows where place contains the letter 'M' and display the remaining rows. (iv)
Database Systems: Design, Implementation, & Management
12th Edition
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Carlos Coronel, Steven Morris
Chapter7: Introduction To Structured Query Language (sql)
Section: Chapter Questions
Problem 6P: Write the SQL code to delete the row for William Smithfield, who was hired on June 22, 2004, and...
Related questions
Question
100%
kindly answer only the questions marked in blue ink .The question is base d in mysql
Transcribed Image Text:10:31
25
Q.2 Write a query in MYSQL to do
i) Display structure of the table.
ii) Display all the records
ii) Change name of the column DEPARTMENT_ID to DPT_ID and name of the
column last_name to l_name. Check the new titles.
iv) Delete the details of employee whose id is 143. Check the change.
Change MANAGER_ID of an employee whose last name is Higgins, to 124.
vi) Display distinct JOB_ID
vii) Display the last name and salary for all employees whose salary is not in the
range of 5000 and 12000.
viii) Change name of the column hire date to startdate. Check the change.
ix) Display the last name, job ID and start date of employees hired between
February 20,1999 and May 31,1999. Order the query result in ascending
order by start date.
Display first name and startdate of every employee who was hired in 1994.
xi) Display the last name and job title of all employees who do not have
manager.
xii) Display the last name of all employees who have an 'a' and an 'e'in their last
name.
xiii) Display the last name of all employees who have an 'a' or 'e' in their last
name. Sort the records in alphabetical orders of last name.
kinCreate a new column commission and enter commission as 20% for Eleni and
Jonathan and as 15% for Kimberely.
xv) For each employee, display the employee number, last name, salary and
salary increased by 15%. Label the column as New salary.
xvi) Create a query that displays the employee's last name and salary. Sort the
date in descending of salary.
![MYSQL-2
Sem - V
B.Sc.
Practical No.2
a) Create a table with the following columns. (Give name of your
choice)
Name of employee ( NAME, variable character)
Date of birth (DOB, date).
Salary of employee (SALARY, integer).
Department (DEPT ,variable character).
[Department: SALE, ACCT, MARKETING]
Enter at least 10 records.
b) Give SQL queries for the following
Give details of all employees in the company.
(i)
(ii)
List names of employees along with their salaries.
(iii)
(iv)
Give details of employees from SALE department.
Give details of employees with salary between 5000 and
10000.
(v)
Add two more records.
(vi)
Give name, date of birth and salary of employees with
department ACCT and salary more than 20000.
List the names & date of birth of employee whose name
(vi)
starts with 'B'.
List names of all employees whose salary is greater than
Display the names of distinct departments.
List names of all the employees with first three
characters unknown and ending with NI.
Display name, department and date of birth of those employees
whose date of birth is before a particular date.
(vii)
30000.
(ix)
(x)
xi)
Create a database in your name and do the following.
1. Create table MyFriends (Friend Id int), (Name varchar(20)),(Age int),
(Salary dec(9,2)),(D_birth date). Enter 10 records.
Display all rows.
Insert a new column place(varchar)
Supply values for the newly added column and Display all rows.
Display Sum, maximum, minimum and average values of salary.
Delete rows where place contains the letter 'M' and display the
remaining rows.
Delete the table MyFriend from the database.
(i)
(ii)
(iv)
(vi)](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fd312b36f-5baa-4587-8c8f-53e7d3457cc6%2Fbc52d7f1-d6e0-40ad-86e6-dcd799cc8165%2Fwnm6w1_processed.jpeg&w=3840&q=75)
Transcribed Image Text:MYSQL-2
Sem - V
B.Sc.
Practical No.2
a) Create a table with the following columns. (Give name of your
choice)
Name of employee ( NAME, variable character)
Date of birth (DOB, date).
Salary of employee (SALARY, integer).
Department (DEPT ,variable character).
[Department: SALE, ACCT, MARKETING]
Enter at least 10 records.
b) Give SQL queries for the following
Give details of all employees in the company.
(i)
(ii)
List names of employees along with their salaries.
(iii)
(iv)
Give details of employees from SALE department.
Give details of employees with salary between 5000 and
10000.
(v)
Add two more records.
(vi)
Give name, date of birth and salary of employees with
department ACCT and salary more than 20000.
List the names & date of birth of employee whose name
(vi)
starts with 'B'.
List names of all employees whose salary is greater than
Display the names of distinct departments.
List names of all the employees with first three
characters unknown and ending with NI.
Display name, department and date of birth of those employees
whose date of birth is before a particular date.
(vii)
30000.
(ix)
(x)
xi)
Create a database in your name and do the following.
1. Create table MyFriends (Friend Id int), (Name varchar(20)),(Age int),
(Salary dec(9,2)),(D_birth date). Enter 10 records.
Display all rows.
Insert a new column place(varchar)
Supply values for the newly added column and Display all rows.
Display Sum, maximum, minimum and average values of salary.
Delete rows where place contains the letter 'M' and display the
remaining rows.
Delete the table MyFriend from the database.
(i)
(ii)
(iv)
(vi)
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
C++ Programming: From Problem Analysis to Program…
Computer Science
ISBN:
9781337102087
Author:
D. S. Malik
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
C++ Programming: From Problem Analysis to Program…
Computer Science
ISBN:
9781337102087
Author:
D. S. Malik
Publisher:
Cengage Learning
