Question

List the names of all criminals who have had any of the crime code charges involved in crime id 10089

Answer 1

Answer:

SELECT crims.criminal_id, crims.first, crims.last, crim.crime_id FROM criminals crims JOIN crimes crim ON crims.criminal_id = crim.criminal_id WHERE crime_id= 10089;

Explanation:

This question deals with the knowledge on a programming language. It is about an extension that is been used with programming language which is known as the SQL (with full meaning; Structured Query Language). Therefore, we must not that Structured Query Language is not a programming language itself but a query language.

The Structured Query Language, that is SQL is used mainly for updating and retrieving information.

The names of all criminals in the crime code of 10089 can be written in SQL language as;

" SELECT crims.criminal_id, crims.first, crims.last, crim.crime_id FROM criminals crims JOIN crimes crim ON crims.criminal_id = crim.criminal_id WHERE crime_id= 10089; ".