Scribd
Upload
9 views2 pages

SQL Basics Assignment

The document outlines a set of SQL tasks to be completed using the tables STUDIES, SOFTWARE, and PROGRAMMER. Tasks include calculating average selling costs, displaying programmer details, and retrieving information based on specific criteria such as course completion and programming languages. The focus is on querying data to extract relevant information from the specified tables.

Uploaded by

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

SQL Basics Assignment

The document outlines a set of SQL tasks to be completed using the tables STUDIES, SOFTWARE, and PROGRAMMER. Tasks include calculating average selling costs, displaying programmer details, and retrieving information based on specific criteria such as course completion and programming languages. The focus is on querying data to extract relevant information from the specified tables.

Uploaded by

Ekant Das
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

SQL - Basics

support@intellipaat.com

+91-7022374614

US: 1-800-216-8930 (Toll-Free)


Problem Statement: Consider yourself to be Sam and you have been given the below tasks to
complete using the Table – STUDIES, SOFTWARE & PROGRAMMER.

1. Find out the selling cost AVG for packages developed in Pascal.
2. Display Names, Ages of all Programmers.
3. Display the Names of those who have done the DAP Course.
4. Display the Names and Date of Births of all Programmers Born in January.
5. Display the Details of the Software Developed by Ramesh.
6. Display the Details of Packages for which Development Cost have been recovered.
7. Display the details of the Programmers Knowing C.
8. What are the Languages studied by Male Programmers?
9. Display the details of the Programmers who joined before 1990.
10. Who are the authors of the Packages, which have recovered more than double the
Development cost?

You might also like