Due Sep 19, 2024
Execute the four scrips in ../examples that create four example databases.
The Sales Database
The App Database
The Nation Database
The Hotel Database
Explore the contents of the databases.
Update the university database to populate at least 1000 students and populate
Write the following queries
(University) Show the names all students from Texas
(Sales) Show all products with the buy price exceeding $100.00
(Nations) Show all countries that are bigger than 1/2 million square km.
import datajoint as dj
schema = dj.Schema('university')schema.spawn_missing_classes()
dj.Diagram(schema)Loading...
Student() & 'sex="F"' & "date_of_birth < '2000-01-01'"Loading...
%%sql
SELECT * FROM `unversity`.`student` WHERE home_state="TX"UsageError: Cell magic `%%sql` not found.