Scribd
Upload
5 views17 pages

SQL Experiments: Student & Customer Queries

The document outlines a series of SQL experiments involving operations on student and customer tables, including creating tables, inserting and deleting records, and performing various queries such as selecting, aggregating, and formatting data. Each experiment is described with a title and includes a placeholder for the program and output. The focus is on practical SQL commands and their applications in database management.

Uploaded by

Bharat singh bhati
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
5 views17 pages

SQL Experiments: Student & Customer Queries

The document outlines a series of SQL experiments involving operations on student and customer tables, including creating tables, inserting and deleting records, and performing various queries such as selecting, aggregating, and formatting data. Each experiment is described with a title and includes a placeholder for the program and output. The focus is on practical SQL commands and their applications in database management.

Uploaded by

Bharat singh bhati
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

Experiment 1

Create a student table with the student id, name and marks as
attributes where the student’s id is the primary key.

Program

Output
Experiment 2
Insert the details of a new student in the above table (Student)

Program

Output
Experiment 3
Delete the details of a student in the above table (Student)

Program

Output
Experiment 4
Use the select command to get the details of the students with marks
more than 999 in the above table (Student).

Program

Output
Experiment 5
Find the Min, Max, Sum and Average of the Marks in the Student Mark
Table.

Program

Output
Experiment 6
Find the total number of customers from each country in the table
(customer_ID, customer_name, country) using group by.

Program

Output
Experiment 7
Write a SQL command to Order the (Student ID, Marks) table of marks
in ascending order.

Program

Output
Experiment 8
Find the Record which having the Customer Name ‘Bharat’, from each
country in the table (customer id, customer name, country) using group
by & having function.

Program

Output
Experiment 9
Write a SQL Query to Find the “POWER, MOD” of Marks and “ROUND”
of the Percentage in the Table (Name, Marks, Percentage).

Program

Output
Experiment 10
Write a SQL Query to Find the “LENGTH, INSTR” of Book Name and
Convert the Book Name using “LCASE, UCASE”, in the Table (Book
Details).

Program

Output
Experiment 11
Write a SQL Query to Select the Book Name, using “MID, LEFT, RIGHT,
LTRIM, RTRIM” in the Table (Book No, Book Name, Book Price).

Program
Output
Experiment 12
Write a SQL Query to Select the Book Name, using “MID, LEFT, RIGHT,
LTRIM, RTRIM” in the Table (Book No, Book Name, Book Price).

Program

Output
Experiment 13
Write a SQL Query to Return the “NOW, DAYNAME, MONTHNAME” of
Start Date in the Table (Use the table Loan_Account)

Program

Output

You might also like