Scribd
Upload
2 views6 pages

Date Base Lab Task

The document outlines a lab task for a Database Systems course, focusing on SQL queries related to patient data. It includes basic, intermediate, and pattern matching conditions for querying a hospital database. The tasks involve filtering patients based on age, city, admission fee, gender, and disease criteria.

Uploaded by

khansaadks121
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
2 views6 pages

Date Base Lab Task

The document outlines a lab task for a Database Systems course, focusing on SQL queries related to patient data. It includes basic, intermediate, and pattern matching conditions for querying a hospital database. The tasks involve filtering patients based on age, city, admission fee, gender, and disease criteria.

Uploaded by

khansaadks121
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

LAB TASK

Hospital DB Course
Title:
Database Systems (Lab)

Course Code:
IT-244

Name:
Saad Khan

Roll No:
25021556-095

Section:
B

Submitted To:
Noor Fatima

Department:
Information Technology

University of Gujrat Hafiz Hayat Campus


SQL Query
SQL Query – Basic Conditions

SQL Query – Intermediate Conditions

SQL Query – Pattern Matching

Basic Conditions
1. Basic Conditions Show all patients whose age is greater than 40.

2. Show patients from Sialkot.

3. Show patients whose admission fee is greater than 10000.

4. Show female patients only.

5. Show Male patients only.


6. Show patients suffering from Diabetes.

Intermediate Conditions
6. Show patients whose age is greater than 40 AND city is Sambrial.

7. Show patients with admission fee between 10000 and 50000.

8. Show patients with disease diabetes OR Stomach pain..

9. Show patients who are NOT from Sambrial.

10. Show patients whose age is less than 30.


Pattern Matching
11. Show patients whose name starts with 'A'.

12. Show patients whose name ends with 'Ali'.

13. Show patients whose disease contains the word 'Stomach'.

14. Show cities that start with 'S'.

You might also like