Answered step by step
Verified Expert Solution
Question
1 Approved Answer
For the following questions, refer to the following table of Disney characters, created as: CREATE TABLE characters ( id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
For the following questions, refer to the following table of Disney characters, created as:
CREATE TABLE characters ( id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, name VARCHAR(20), movie VARCHAR(20), year INT, toys_sold DEC(5,2), type INT);
id | name | movie | year | toys_sold | type |
1 | Captain Hook | Peter Pan | 1953 | 30 | 2 |
2 | Tiger Lily | Peter Pan | 1953 | 10 | 1 |
3 | Pocahontas | Pocahontas | 1995 | 20 | 1 |
4 | Meeko | Pocahontas | 1995 | 5 |
|
5 | Woody | Toy Story |
| 45 | 4 |
6 | Flik | A Bugs Life | 1998 | 5 | 3 |
7 | Dot | A Bugs Life | 1998 | 5 | 3 |
8 | Sofia, the First | Forever Royal | 2018 | 50 | 1 |
- Write a SQL statement to change the table to not allow decimal places in toys_sold.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started