study_SQLs_

where_in_subquery : 서브쿼리를 IN 이용해 활용😎

• Query_byeongjuPark
• Query_BY.HyeonTTora

where_and_not : AND_NOT 을 이용해 활용 🦥

• Query_byeongjuPark
• AND_NOT_BY.HyeonTTora

Employees_Order_totals : COUNT을 활용 🐱‍🐉

• Query_byeongjuPark
• COUNT_BY.HyeonTTora

Categoires_Products_total : COUNT을 활용2 (❁´◡`❁)

• Query_byeongjuPark
• COUNT2_BY.HyeonTTora

CategoryName_Products : 합계와 평균 😎

• Query_byeongjuPark
• SUM_AVG_BY.HyeonTTora

CategoryName_Products_Order : 끔찍한 서브쿼리 🤬

• Query_byeongjuPark
• Query2_BY.HyeonTTora

Categories_Products_Count : GROUP BY 활용 o((>ω< ))o

• Query_byeongjuPark
• GROUP_BY.HyeonTTora

Produts_HAVING : HAVING 활용 🦄

• Query_byeongjuPark
• Having_BY.HyeonTTora

Users_Auths_query : MySQL로 DB,Tables생성 후 회원 가입,탈퇴🤖

• Users_Auths.HyeonTTora
• Query_byeongjuPark

Products_CategoryID : JOIN 활용🪄

• Query_byeongjuPark
• JOIN_BY.HyeonTTora

Products_Quantity : Join 활용2🪄

• Query_byeongjuPark
• JOIN2_BY.HyeonTTora

Users_Auth_names : Join 의 Join🤯

• Query_byeongjuPark
• JOIN3_BY.HyeonTTora