It is required to process information located in two tables. The users table stores data about users and has fields: user_id, name, second_name, job_id (profession identifier), and car (type of car, possible options: "Government car" or "Personal car"). The jobs table contains information about professions with fields: job_id, job (profession, options: "Programmer", "Firefighter", "Taxi driver", "Lawyer") and ipoteka (type of mortgage, options: "Preferential" or "Non-preferential").

Previous Next