logo

Crowdly

Browser

Додати до Chrome

Questions Bank (1231900 total)

List all the artist and the number of unique works.

Переглянути це питання

List the work ID, title and artist name of all the works of art that sold for more than the average price of all sales, and the price they sold for. (use subquery)

Переглянути це питання

List the full name of each artist represented in the database and the number of works of art by that artist, for those artists that have more than four (4) works of art in the gallery.

Переглянути це питання

List the names of customers and the sum of sales prices for their transactions, considering only transactions with a sales price exceeding $500.

Переглянути це питання

List the details of any work of art (including the name of the artist who created the work and the acquisition and asking price details) currently held in the gallery (i.e. works of art that have not been sold) with an asking price of > $400.

Переглянути це питання

Esta es la vista de diseño de la tabla GRADE.

¿Cuál es la clave primaria de la tabla GRADE?

Переглянути це питання

Use vrg database to answer the following questions

List the full details of any work of art,

including the name of the artist who created the work, that have been described

as Surrealist.

Переглянути це питання

¿Cuál de las siguientes instrucciones en SQL devolvería solo el nombre del representante de ventas y el nombre del cliente para cada cliente que tenga un saldo mayor a 400?

Переглянути це питання

¿Qué asegura la integridad de entidad en una base de datos?

Переглянути це питання

¿Qué implica la integridad de dominio en una base de datos?

Переглянути це питання