# Capgemini Adapt 2022 Toy Rental A Solutions for Sprint 3 Learning Outcome 1

The problems of  Toy Rental LO 1 are – Available Toys, Toys based on Age, Customer Ascending Order, and Customer Count. In this post, you will get the solution to the Capgemini ADAPT 2022 solutions to the problems of Toy Rental A Learning Outcome 1.

Note: The solutions are provided for learning purposes only.

## Toy Rental A – SQL Problem Solutions – Learning Outcome 1:

### 1.TR1-1-Available Toys:

alter session set current_schema = mt_toy;

SELECT TOY_ID, TOY_NAME, TOY_TYPE, MIN_AGE, MAX_AGE, PRICE,

QUANTITY, RENTAL_AMOUNT FROM TOY;

### 2.TR1-2-Toys based on the Age:

alter session set current_schema = mt_toy;

SELECT * FROM TOY
WHERE MIN_AGE < 4 OR MAX_AGE < 4;

### 3.TR1-3-Customer Ascending order:

alter session set current_schema = mt_toy;

SELECT * FROM customer

ORDER BY customer_name ASC;

### 4. TR1-4-Customer Count:

alter session set current_schema = mt_toy;

SELECT city, COUNT(*) AS TOTAL

FROM customer

GROUP BY city;

## Top Companies + Batchwise Hiring Drive:

 TOP COMPANIES HIRING DRIVE BATCHWISE HIRING DRIVES