Computer scienceFundamentalsSQL and DatabasesBasics SQLData Modification Language

Basic DELETE statement

Theory

Artificial selection

Report a typo

We have a table movies:

title rating year
Pulp Fiction 8.9 1994
The Godfather 9.2 1972
The Shining 8.4 1980
Jurassic Park 8.1 1993

Delete all the movies which have been released after 1980 inclusive and have ratings less than 8.5.

Write an SQL statement





___

Create a free account to access the full topic