HTSQL Sample Database Gallery¶
This gallery is for examples and dashboards based on our sample database which is a dummy university course catalog & enrollment system.
University Dashboards¶
The Course Catalog dashboard lets you drill down to individual courses by first selecting the school, then clicking on the department name. The dashboard updates in real time and always features the most current data because HTSQL pulls it directly from the database.
Schema Diagram¶
Sample Queries¶
Welcome to HTSQL’s test database, where we put HTSQL through its paces with a complex database structure. The courses are fake, but the problems solved are real, as these queries show how easy it is to aggregate and analyze course data from multiple tables. For a complete tour of this database and HTSQL, visit the HTSQL Tutorial.
Average number of courses per department in each school¶
| name | avg(department.count(course)) |
|---|---|
| School of Art and Design | 19.5 |
| School of Business | 14.6666666667 |
| College of Education | 17.5 |
| School of Engineering | 17.75 |
| … | … |
Courses in the Business School in CSV format¶
code,name,no,title
acc,Accounting,234,Accounting Information Systems
acc,Accounting,620,Accounting Internship
acc,Accounting,527,Advanced Accounting
mm,Management & Marketing,434,Advertising
econ,Economics,213,American Economic History
acc,Accounting,511,Audit
econ,Economics,321,Banking System
mm,Management & Marketing,756,Capital Risk Management
mm,Management & Marketing,601,Case Studies in Corporate Finance
mm,Management & Marketing,401,Competitive Strategy
acc,Accounting,506,Corporate Financial Law
mm,Management & Marketing,404,Corporate Financial Management
acc,Accounting,426,Corporate Taxation
econ,Economics,430,Econometrics
acc,Accounting,315,Financial Accounting
mm,Management & Marketing,818,Financial Statement Analysis
econ,Economics,370,Game Theory
econ,Economics,452,Government Finance
econ,Economics,352,History of Economic Thought
mm,Management & Marketing,355,Human Resource Management
acc,Accounting,420,Individual Taxation
mm,Management & Marketing,531,International Business
econ,Economics,412,International Financial Markets
mm,Management & Marketing,650,International Marketing
acc,Accounting,200,Introduction to Accounting
econ,Economics,205,Introduction to Global Economy
econ,Economics,102,Introduction to Macroeconomics
econ,Economics,101,Introduction to Microeconomics
econ,Economics,339,Labor Economics
acc,Accounting,322,Managerial Accounting
mm,Management & Marketing,304,Managerial Economics I
mm,Management & Marketing,305,Managerial Economics II
mm,Management & Marketing,331,Marketing Planning
mm,Management & Marketing,318,Marketing Research
econ,Economics,246,Microeconomic Theory
acc,Accounting,431,Nonprofit Organization Accounting
acc,Accounting,100,Practical Bookkeeping
mm,Management & Marketing,256,Principles of Marketing
mm,Management & Marketing,808,Principles of Portfolio Management
mm,Management & Marketing,520,Project Management
mm,Management & Marketing,430,Promotion
econ,Economics,112,Quantitative Method in Microeconomics
econ,Economics,489,Special Topics in Economics
econ,Economics,278,Statistics in Economics