Object modification with ORM

Django ORM vs SQL syntax

Report a typo

Match the Django ORM query syntax with their SQL query equivalent.

Match the items from left and right columns

Model.objects.all()

Model.objects.filter(name='Evelyn')

Model.objects.exclude(name='Evelyn')

Model.objects.order_by('popularity')

Model.objects.create(name='Jane', age=23, popularity=9)

INSERT INTO Model VALUES ('Jane', '23', '9');

SELECT * FROM Model WHERE name='Evelyn';

SELECT * FROM Model WHERE NOT name='Evelyn';

SELECT * FROM Model;

SELECT * FROM Model ORDER BY popularity;

___

Create a free account to access the full topic