Scribd
Upload
108 views2 pages

DBMS Lab Practical: SQL Queries

The document outlines a DBMS lab assignment consisting of two parts. Part 1 includes SQL queries related to employee details and salary conditions, while Part 2 focuses on customer data and requires SQL queries to filter customers based on grade and city. The assignment emphasizes practical SQL skills for data retrieval and manipulation.

Uploaded by

saifullahfaizan786
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
108 views2 pages

DBMS Lab Practical: SQL Queries

The document outlines a DBMS lab assignment consisting of two parts. Part 1 includes SQL queries related to employee details and salary conditions, while Part 2 focuses on customer data and requires SQL queries to filter customers based on grade and city. The assignment emphasizes practical SQL skills for data retrieval and manipulation.

Uploaded by

saifullahfaizan786
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

PCA1

Paper Code: BCAC491


Paper Name: DBMS Lab

Part 1

1. Select the detail of the employee whose name start with P.


2. How many permanent candidate take salary more than 5000.
3. Select the detail of employee whose emailId is in gmail.
4. List name of all employees whose name ends with a.
5. Select the name of the employee whose name's 3rd charactor is 'h'.
6. Select the names of the names who take salary more than 5000.
7. Select the name and employeeID of the all the candidates who is not
permanent.

Part 2

customer_id cust_name city grade salesman_id

3002 Nick Rimando New York 100 5001

3007 Brad Davis New York 200 5001

3005 Graham Zusi California 200 5002

3008 Julian Green London 300 5002

3004 Fabian Johnson Paris 300 5006

3009 Geoff Cameron Berlin 100 5003

3003 Jozy Altidor Moscow 200 5007

3001 Brad Guzan London 5005


1) From the following table, write a SQL query to locate the details of customers with grade
values above 100. Return customer_id, cust_name, city, grade, and salesman_id.
2) From the following table, write a SQL query to find all the customers in ‘New York’ city who
have a grade value above 100. Return customer_id, cust_name, city, grade, and salesman_id.
3) From the following table, write a SQL query to find customers who are either from the city
'New York' or who do not have a grade greater than 100. Return customer_id, cust_name, city,
grade, and salesman_id.

You might also like