Computer scienceFundamentalsSQL and DatabasesDBMSPostgreSQLPostgreSQL with Node.js

Queries with pg

Theory

SQL query definition

Report a typo

Match the SQL query with its description:

Match the items from left and right columns
INSERT INTO customers(name, email) VALUES('John', '[email protected]');
UPDATE products SET price = price * 0.9;
DELETE FROM orders WHERE order_date < '2023-01-01';
Deletes orders placed before January 1, 2023.
Inserts a new customer with a name and email.
Updates the prices of products by reducing them by 10%.
___

Create a free account to access the full topic