(1) Install MySQL in your computer. You may also install xampp instead of just M

Question

(1) Install MySQL in your computer. You may also install xampp instead of just MySQL. Install the 'Big' PVFC database of the textbook in MySQL and call the database 'bigpvfc'. You may execute the sql file, bigpvfc.sql (provided separately), in MySQL console.

Provide the MySQL commands for the following queries.

(d) List some information of raw materials made of walnut with a width of 9 or more in the following format.

+--------------+-------------------------------+-----------+-------+----------+--------+
| MaterialId   | MaterialName                  | Thickness | Width | Material | price |
+--------------+-------------------------------+-----------+-------+----------+--------+
| 1-1/21010WAL | 1-1/2in X 10in X 10ft Walnut | 1-1/2     | 10    | Walnut   |   67.5 |
| 1-1/21012WAL | 1-1/2in X 10in X 12ft Walnut | 1-1/2     | 10    | Walnut   |     81 |
| 1-1/21016WAL | 1-1/2in X 10in X 16ft Walnut | 1-1/2     | 10    | Walnut   |    108 |
...
| 61216WAL     | 6in X 12in X 16ft Walnut     | 6         | 12    | Walnut   |    648 |
| 6124WAL      | 6in X 12in X 4ft Walnut      | 6         | 12    | Walnut   |    162 |
| 6128WAL      | 6in X 12in X 8ft Walnut      | 6         | 12    | Walnut   |    324 |
+--------------+-------------------------------+-----------+-------+----------+--------+
130 rows in set (0.00 sec)

Explanation / Answer

SELECT MaterialId, MaterialName, Thickness, Width, Material, price from pvfc where Material = 'Walnut' AND Width >= 9

Related Questions

Navigate

• Browse (All)
• Browse #
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.