INSERT INTO solar_system_objects(body,mean_radius,mean_radius_rel,volume,volume_rel,mass,mass_rel,density,surface_gravity,surface_gravity_rel,type_of_object,shape) VALUES ( 'Io ', 1821. INSERT INTO solar_system_objects(body,mean_radius,mean_radius_rel,volume,volume_rel,mass,mass_rel,density,surface_gravity,surface_gravity_rel,type_of_object,shape) VALUES ( 'Callisto ', 2410. INSERT INTO solar_system_objects(body,mean_radius,mean_radius_rel,volume,volume_rel,mass,mass_rel,density,surface_gravity,surface_gravity_rel,type_of_object,shape) VALUES ( 'Mercury ', 2439.
INSERT INTO solar_system_objects(body,mean_radius,mean_radius_rel,volume,volume_rel,mass,mass_rel,density,surface_gravity,surface_gravity_rel,type_of_object,shape) VALUES ( 'Titan ', 2576, 0. INSERT INTO solar_system_objects(body,mean_radius,mean_radius_rel,volume,volume_rel,mass,mass_rel,density,surface_gravity,surface_gravity_rel,type_of_object,shape) VALUES ( 'Ganymede ', 2634. INSERT INTO solar_system_objects(body,mean_radius,mean_radius_rel,volume,volume_rel,mass,mass_rel,density,surface_gravity,surface_gravity_rel,type_of_object,shape) VALUES ( 'Mars ', 3389. INSERT INTO solar_system_objects(body,mean_radius,mean_radius_rel,volume,volume_rel,mass,mass_rel,density,surface_gravity,surface_gravity_rel,type_of_object,shape) VALUES ( 'Venus ', 6051. INSERT INTO solar_system_objects(body,mean_radius,mean_radius_rel,volume,volume_rel,mass,mass_rel,density,surface_gravity,surface_gravity_rel,type_of_object,shape) VALUES ( 'Earth ', 6371, 1, 1083. 14, 'planet (ice giant) has rings ', 'round ') INSERT INTO solar_system_objects(body,mean_radius,mean_radius_rel,volume,volume_rel,mass,mass_rel,density,surface_gravity,surface_gravity_rel,type_of_object,shape) VALUES ( 'Neptune ', 24622, 3. 9, 'planet (ice giant) has rings ', 'round ') INSERT INTO solar_system_objects(body,mean_radius,mean_radius_rel,volume,volume_rel,mass,mass_rel,density,surface_gravity,surface_gravity_rel,type_of_object,shape) VALUES ( 'Uranus ', 25362, 3. 06, 'planet (gas giant) has rings ', 'round ') INSERT INTO solar_system_objects(body,mean_radius,mean_radius_rel,volume,volume_rel,mass,mass_rel,density,surface_gravity,surface_gravity_rel,type_of_object,shape) VALUES ( 'Saturn ', 58232, 9. 535, 'planet (gas giant) has rings ', 'round ') INSERT INTO solar_system_objects(body,mean_radius,mean_radius_rel,volume,volume_rel,mass,mass_rel,density,surface_gravity,surface_gravity_rel,type_of_object,shape) VALUES ( 'Jupiter ', 69911, 10. INSERT INTO solar_system_objects(body,mean_radius,mean_radius_rel,volume,volume_rel,mass,mass_rel,density,surface_gravity,surface_gravity_rel,type_of_object,shape) VALUES ( 'Sun ', 696342, 109. , surface_gravity_rel NUMERIC /* relative to earth */ , mass_rel NUMERIC /* relative to earth */ , volume_rel NUMERIC /* relative to earth */ , mean_radius_rel NUMERIC /* relative to earth */
What interesting ways are there to filter the data (using AND/OR)? */ What ways are there to group the data values that don’t exist yet (using CASE)? What about those numbers per category in the data (using HAVING)? What are average, max, and min values in the data?
They were using it for an app or a business idea? Here are some ideas: What sort of questions might one have about that data, like if Pick one of those data sets or create a data set like that, and use advanced SELECT queries toĭiscover things about the data. Winston's donut logs, Card game results, and NFL draft picks. Solar system objects by size, Marvel characters, Furniture store sales, Earned KA badges, *We’ve curated a set of interesting data sets for you: Top movies, Top countries by population,
0 kommentar(er)
