We would like to use Google Analytics to understand how people use Insyt. It sets cookies and only runs if you accept. Rejecting changes nothing else on the site.
Practice/SQL
Choose how to practise: solve a work request, complete a checked challenge, write your own SQL or explore the data. No account required.
Each company has staff in all nine Functions, so there is work for every role. You can move company at any time, and your progress at each one is kept in this browser.
Makes precision rocket parts: valves, tanks, structures and flight computers for universities, industry and rocket builders.
18 tables, 144,790 rows: customers, customer_invoices, credit_notes, supplier_invoices and the people, finance and IT tables every company has.
Runs seven ground stations in Sweden and Norway that talk to satellites, plus a rocket test site and mission software.
20 tables, 45,940 rows: customers, customer_invoices, credit_notes, supplier_invoices and the people, finance and IT tables every company has.
Builds small rockets and launches satellites from Scotland, on dedicated launches or shared seats.
17 tables, 16,572 rows: customers, customer_invoices, supplier_invoices, products and the people, finance and IT tables every company has.
A public observatory and planetarium: northern lights evenings, shows, school groups, members and a café.
18 tables, 61,773 rows: customers, customer_invoices, supplier_invoices, products and the people, finance and IT tables every company has.
Sells satellite imagery and data to farms, insurers and governments, mostly as yearly subscriptions.
19 tables, 63,993 rows: customers, customer_invoices, credit_notes, supplier_invoices and the people, finance and IT tables every company has.
Nine requests are waiting, one from each Function. Open one, ask the colleague what you need to know, then send your answer.
One harder question on the Raket Parts B.V. data. Your answer is checked against the data.
Write any query on the Raket Parts B.V. tables. No marking, run anything.
This box has its own copy of the data, so you can change or delete rows without affecting anything else. Reset brings back the starting data and query.
Kept in this browser on this device, so you can come back to them.