Ultimate access to all questions.
A SQL notebook scheduled for daily execution contains a cell with the following statements aimed at dropping a table named billing
if it exists, before creating and inserting values into the table. The statements are: DROP TABLE billing;
, CREATE TABLE billing (item string, quantity int, price float);
, and INSERT INTO billing VALUES (‘DP‘, 5, 500.00);
. What modifications, if any, are needed to ensure the DROP TABLE
statement does not throw an error?