Skip to content

byeongjuPark/study_SQLs

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

91 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

study_SQLs_

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

where_and_not : AND_NOT 을 이용해 활용 🦥

Employees_Order_totals : COUNT을 활용 🐱‍🐉

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

CategoryName_Products : 합계와 평균 😎

CategoryName_Products_Order : 끔찍한 서브쿼리 🤬

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

Produts_HAVING : HAVING 활용 🦄

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

Products_CategoryID : JOIN 활용🪄

Products_Quantity : Join 활용2🪄

Users_Auth_names : Join 의 Join🤯

About

깃허브 공유 연습 및 SQL문 작성 연습

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Contributors 2

  •  
  •