Skip to content

PNU CSE 2022 Database Assignment #2 [Django web exercise with MySQL]

Notifications You must be signed in to change notification settings

xet-a/db-django-exercise

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

7 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

db-django-exercise

  • 2022-2 PNU Database Assignment #2 [Django web exercise with MySQL]
  • 복습용 기본 튜토리얼
  • 제가 작성한 SQL query문은 정답이 아니므로 틀릴 수 있습니다.
  • 내용이 잘못되었거나 구현 내용에 궁금하신 점이 있으면 이슈로 남겨주시면 감사하겠습니다.

구현 내용

  • main (back to init state when you click RESET)

  • Create Table

  • Insert Data

  • Query1 : Find the average hard disk size of PCs

  • Query2 : Find the average speed of laptop for each maker

  • Query3 : Find the price of laptop, which is the only laptop model of the maker

  • Query4 : Find the model and price of the printer of the highest price of each maker

About

PNU CSE 2022 Database Assignment #2 [Django web exercise with MySQL]

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published