6.- Given the following relational database below; create database shop; use shop: create table users( id...

Transcribed Image Text:

6.- Given the following relational database below; create database shop; use shop: create table users( id int null auto increment, firstname varchar(255), lastname varchar (255) not null, primary key (id) ); create table products( id int null auto increment. name varchar(255), price float, primary key (id) create table orders( id users int not null, id items int not null, primary key (id users.id_items), foreign key (id users) references users(id), foreign key (id items) references items(id) ); write a SQL query to answer the following questions 1.- Products in the shop catalog, product name, code and price. 2.- Products sold in the shop; product name, code, price and full name of buyer. 6.- Given the following relational database below; create database shop; use shop: create table users( id int null auto increment, firstname varchar(255), lastname varchar (255) not null, primary key (id) ); create table products( id int null auto increment. name varchar(255), price float, primary key (id) create table orders( id users int not null, id items int not null, primary key (id users.id_items), foreign key (id users) references users(id), foreign key (id items) references items(id) ); write a SQL query to answer the following questions 1.- Products in the shop catalog, product name, code and price. 2.- Products sold in the shop; product name, code, price and full name of buyer.