INCLASS ACTIVITY WEEK $15$

School Database:

$1.$ Show the number of students who were successful in the $$Data Base$$ course and the average of

their success grades

$2.$ Show the names of faculty members who taught two or more courses

$3.$ Show the names of all the courses taken by the student named $$Ahmet Solmaz$$ and their

midterm, final and success grades along with these names.

$4.$ Show the names of all students who took lessons from the teacher named $$Zeki Durmu$$

$5.$ How Many Do$.$ Dr$.,$ Yrd$.$ Do$.$ Dr$.$ Ve Uzman at the School?

$6.$ Show the names of the students who took the courses given by the teacher named "Ayd$$n Carus"

and were successful in at least one of them.

Virtual Market Database:

$1.$ Show the name and surname of customers who buy products from 'Nike' company

$2.$ Show the number of customers who made purchases after April

Market Database:

$1.$ Show the dates on which the customer named $$Ahmet Solmaz$$ made purchases

$2.$ Show the name and surname of people who shopped at the market at least $5$ times in November

$2005$

$3.$ Show the average sales prices of products belonging to the product type whose

Product$\_$Type$\_$Name is $$Book$$

$4.$ Show the name and surname of customers who purchased Adidas products in October $2009$

$5.$ Show all customers in order from highest to lowest according to their total spending

$6.$ Show the name of each product type and the name of the product with the highest sales price in

that product type

$7.$ Show the name of the most sold discounted product in the last $2$ weeks

$8.$ Names of cashier$($s$)$ who worked on the $7$th of the month and whose salary was $700$ lira or more

$9.$ Number of books in the book category with a profit of more than $4$ lira

$10.$ Names of companies that offer discounts on food products

$11.$ Among the discounted products sold in the store, the name, purchase price, sales price,

discounted price and profit of the product that causes loss to the store after the discount.