SQL Arena
#1133

Coupons: unique code and discount range

Design a coupons table: the code is required and unique, and the discount pct is an integer from 1 to 100. Columns: id — primary key; code; pct.

Samo CREATE/ALTER/DROP — zaključni SELECT ni potreben.

Prijavite se za oddajo

Rezultat vaše poizvedbe se bo prikazal tukaj

Brez začetne sheme

Ta naloga se začne brez tabel — ustvarili jih boste z ukazom CREATE TABLE.