contestada

Create a query to insert into a new table, called Purchase61, the purchase records of employee 61 made after Christmas in 2014 (i.e., between December 26, 2014, and December 31, 2014. (Use between. Use date format of 'yyyy-mm-dd')

Respuesta :

lhmarianateixeira

Using the codes in computational language in python it is possible to write a code that Create a query to insert into a new table, called Purchase61, the purchase records of employee 61 made after Christmas

Writting the code:

INSERT INTO redcat.Purchase61(PurchaseID, PurchaseDate, EmployeeID, ExpectedDeliveryDate, ManufactutrerID, Shipping)

SELECT

     PurchaseID,

     PurchaseDate,

     EmployeeID,

     ExpectedDeliveryDate,

     ManufactutrerID,

     Shipping

FROM

    redcat.Purchase

WHERE

    EmployeeID = 61

AND  PurchaseDate BETWEEN DATE '2014-12-26' AND DATE '2014-12-31';

See more about python at brainly.com/question/18502436

#SPJ1

Ver imagen lhmarianateixeira

Otras preguntas