Consider below table:PRODUCTPrimary keyintegerProductidStringproductnameDoublepriceSALEprimary keyintegersaleIdforeign key PRODUCT$($productIdintegerproductIdNot nullintegerquantityNot nullDoubletotalPriceDatesaleDate$1-$write a query to display productId,productName, and price which is sold today$\mathrm{.}2-$write a query to display total sale by saleDate$\mathrm{.}3-$write a query to display most sold product$\mathrm{.}4-$create view daily$\_$sale$\_$summary on query written in $(2)\mathrm{.}5-$ create a user student and grant permission to login$,$ create table, create view and quota $10$g on users tablespace.

Consider below table:

PRODUCT

Primary key integer Productid

String productname

Double price

SALE

primary key integer saleld foreign key PRODUCT $($productld integer productld

Not null integer quantity

Not null Double totalPrice

Date saleDate

$1-$write a query to display productld, productName, and price which is sold today.

$2-$write a query to display total sale by saleDate.

$3-$write a query to display most sold product.