Scribd
Upload
176 views3 pages

Capability5 Assignment

This document outlines assignments to develop skills in writing SELECT queries with joins, grouping, aggregation and filtering. Exercises include completing online tutorials on basic SELECT statements, joins, aggregation functions and a SQL quiz. One assignment involves writing a query on an employee table to return the manager ID, name and average salary of employees under each manager. The goal is to gain proficiency in writing SELECT queries using concepts covered which include basic SELECT statements, joins, aggregation functions and grouping.

Uploaded by

Barbarous Shuvankar
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
176 views3 pages

Capability5 Assignment

This document outlines assignments to develop skills in writing SELECT queries with joins, grouping, aggregation and filtering. Exercises include completing online tutorials on basic SELECT statements, joins, aggregation functions and a SQL quiz. One assignment involves writing a query on an employee table to return the manager ID, name and average salary of employees under each manager. The goal is to gain proficiency in writing SELECT queries using concepts covered which include basic SELECT statements, joins, aggregation functions and grouping.

Uploaded by

Barbarous Shuvankar
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/ 3

Basecamp Capability 5 Assignments

Introduction:
This document covers list of assignments/exercises related to fifth capability of
Basecamp program:

Write select queries to retrieve specific set of data from given database

Observations:

KO: 1. Ability to write basic select queries and retrieve data


KO: 2. Ability to use Join (inner and outer joins) and Having clause in select queries,
group by, order by and limit)
3. Ability to use SQL numeric functions - AVG, COUNT, FLOOR, GREATEST

@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

Exercise 1: SELECT Statement


Complete the exercises listed at following URL:
https://www.techonthenet.com/sql/select_exercises.php

Exercise 2: SELECT Statement


Complete at least 30 exercises listed at following URL:
https://www.w3resource.com/sql-exercises/sql-retrieve-from-table.php

Exercise 3: SQL Joins


Complete at least 20 exercises listed at following URL:
https://www.w3resource.com/sql-exercises/sql-joins-exercises.php

1
Basecamp Capability 5 Assignments

Exercise 4: Aggregate Functions


Complete at least 20 exercises listed at following URL:
https://www.w3resource.com/sql-exercises/sql-aggregate-functions.php

Exercise 5: SQL Quiz


Complete following online quiz:
https://www.w3schools.com/quiztest/quiztest.asp?qtest=SQL

Exercise 6: Employee Table

Consider the Employee Table below


Emp_Id Emp_name Salary Manager_Id
10 Anil 50000 18
11 Vikas 75000 16

12 Nisha 40000 18
13 Nidhi 60000 17
14 Priya 80000 18
15 Mohit 45000 18

16 Rajesh 90000 -
17 Raman 55000 16
18 Santosh 65000 17

Write a query to generate below output:


Manager_Id Manager Average_Salary_Under_Manager

16 Rajesh 65000
17 Raman 62500
18 Santosh 55000

2
Basecamp Capability 5 Assignments

@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

Summary:
You must have learnt following concepts:
 How to write different types of SELECT statements?
 How to write join statements?
 How to work with aggregate functions?

You might also like