Pages: 2
Rating : ⭐⭐⭐⭐⭐
Price: $10.99
Page 1 Preview
chapter using simple functions select product

Chapter using simple functions select product

Chapter 4: Using Simple Functions 127

SELECT product_type_id, AVG(price)
FROM products
WHERE price < 15
GROUP BY product_type_id
HAVING AVG(price) > 13
ORDER BY product_type_id;

--------------- ----------
3 13.24
2 14.45

In this chapter, you have learned the following:

■ Groups of rows may be filtered using the HAVING clause.

In the next chapter, you’ll learn about dates and times.

You are viewing 1/3rd of the document.Purchase the document to get full access instantly

Immediately available after payment
Both online and downloadable
No strings attached
How It Works
Login account
Login Your Account
Place in cart
Add to Cart
send in the money
Make payment
Document download
Download File

Uploaded by : Charles Holloway

PageId: ELI4B46BCA