Canvas 31 33 $0.10 $0.10 Edit View Insert Format Tools Table $250,000 12pt Paragraph ...

Transcribed Image Text:

Canvas 31 33 $0.10 $0.10 Edit View Insert Format Tools Table $250,000 12pt ✓ Paragraph ✓ ΒΙ $110,000 Write a single SQL statement that would create the above table with the follow criteria. IssueNumber column must be of size 3 Original Price can't be greater than 99.99 Original Price must be not null AveragePrice is a number of 15 digits two of which are reserved for number of pennies. Quantity is a number without decimal points. IssueNumber is the PrimaryKey The table is to be created without any data. AVV 2 ✓ T² v 4 : Canvas 31 33 $0.10 $0.10 Edit View Insert Format Tools Table $250,000 12pt ✓ Paragraph ✓ ΒΙ $110,000 Write a single SQL statement that would create the above table with the follow criteria. IssueNumber column must be of size 3 Original Price can't be greater than 99.99 Original Price must be not null AveragePrice is a number of 15 digits two of which are reserved for number of pennies. Quantity is a number without decimal points. IssueNumber is the PrimaryKey The table is to be created without any data. AVV 2 ✓ T² v 4 :

Answer rating: 100% (QA)

CREATE TABLE Canvas I... View the full answer