Deleting data from a table
DELETE FROM artists_backup
WHERE artistid = 1;
DELETE FROM artists_backup
WHERE name LIKE '%Santana%';
DELETE FROM TRANSACTION
WHERE TransDate < '2019-01-01' ;
DELETE FROM artists_backup
WHERE artistid = 1;
DELETE FROM artists_backup
WHERE name LIKE '%Santana%';
DELETE FROM TRANSACTION
WHERE TransDate < '2019-01-01' ;