SQL Assessment: Set Last Service Date

SQL code copied to buffer

Group tasks by:

complexity

category

database

Support the project.

Task 31:

For every record in the machine table, update the JSON content within the details column. You need to add or update the last_service field within this JSON to reflect today's date.

Use SQLite syntax to write your answer. Descriptions of tables are provided in the right pane.

Write your request in the field below and click the "Check it!" button.

Get hint

Copy code Clear editor

Explore over 370 diverse tasks on our platform.

Querynomicon (SQLite)

A compact database for learning the basics of SQL.

The Querynomicon database contains tables:

department - table of departments.

identDepartment ID
nameDepartment name
buildingBuilding name

ident	name	building
gen	Genetics	Chesson

little_penguins - table of little penguins.

speciesPenguin species
islandIsland of residence
bill_length_mmBill length, mm
bill_depth_mmBill depth, mm
flipper_length_mmFlipper length, mm
body_mass_gBody mass, g
sexSex

species	island	bill_length_mm	bill_depth_mm	flipper_length_mm	body_mass_g	sex
Gentoo	Biscoe	52.1	17	230	5550	MALE

penguins - table of penguins.

speciesPenguin species
islandIsland of residence
bill_length_mmBill length, mm
bill_depth_mmBill depth, mm
flipper_length_mmFlipper length, mm
body_mass_gBody mass, g
sexSex

species	island	bill_length_mm	bill_depth_mm	flipper_length_mm	body_mass_g	sex
Gentoo	Biscoe	52.1	17	230	5550	MALE

staff - table of employees.

identEmployee number
personalEmployee first name
familyEmployee last name
deptDepartment
ageAge

ident	personal	family	dept	age
7	Abram	Chokshi	gen	23

machine - table of machines.

identMachine ID
nameMachine name
detailsJSON with details

ident	name	details
1	WY401	{"acquired": "2023-05-01"}
2	Inphormex	{"acquired": "2021-07-15", "refurbished": "2023-10-22"}
3	AutoPlate 9000	{"note": "needs software update"}

Login

Register

Querynomicon (SQLite)

The Querynomicon database contains tables: