Question: What is the sql code for this assignment suppose to look like I dont have a good understanding of it , I have the Java

What is the sql code for this assignment suppose to look like I dont have a good understanding of it, I have the Java part under control. Create a JavaFX GUI that allows the user to retrieve records from the product table in the example database.The GUI should allow the user to specify desired fields, desired order, and a where condition.Display only the desired fields in the desired order for the desired where condition.You may display the records in the GUI in any way you wish.Sample output - the output fields do not line up but that is not required.Added hints on 2/24/2024-* Make sure the MySQL server is running in the background. The instructions are a bit ambiguous hinting that you should stop it. It must be operational to make this program work.* Start with the simplest SQL statement, such as "Select * FROM Products", once that is working then start adding in the option buttons to build the SQL statement.* To test you will have to type the where cause as shown in the example below, not sure I would count on users to be able to do this.* If you are having trouble with mySQL connect me immediately.* I would not recommend using JavaFX tableview. It is complex, your output works just as well with a textarea.
Products Table
Select fields of Products Table to Display
Vin
Make
Model
Year
Color
Price
where
\table[[12345,Chevrolet,Volt,2013,silver,34000.00,],[22222,Chevrolet,Malibu,2013,red,24000.00,],[49879,Buick Lacrosse,2013,white,38000.00,,],[60842,Buick Enclave,2013,silver,42000.00,],[77776,Cadillac,CTS-V Coupe,2013,blue,40000.00,],[90201,Bugatti Veyron,2013,red,1900000.00,],[99090,Chevrolet,Spark,2013,green 14000.00,,]]
 What is the sql code for this assignment suppose to look

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!