Quiz on Counting, Sorting, and Limiting Results

Test your understanding of the create table, index, count, where, and order by commands.

Question 1

Create the items table. Items should have item_id as the primary key (integer, not null and auto incremented), a description of type varchar with maximum length of 255, and the rate of type numeric with 5 digits before and 2 digits after decimal point. Both name and rate should not be null.

Show Answer

1 of 7

Get hands-on with 1200+ tech skills courses.