Answer to Question #239260 in Java | JSP | JSF for Precioud

Question

1.1)

Given the vehicle table and data above, write down the SQL statement to create 

and populate the table.

(5)

1.2)

Write an SQL query that updates the BMW to Volkswagen and mileage to 65000

(3)

1.3)

Write an SQL query to display the customer id, customer email, vehicle make, 

model and amount. In your query include 10% discount and the total discounted 

amount.

(10)

1.4)

Write an SQL query that displays the different years of vehicles.

(2)

1.5)

Write an SQL query that will display vehicles made in 2018 only.

(2)

1.6)

Write an SQL query to rename the table vehicle to Car.

(2)

1.7)

Write an SQL query to delete the Car table.

(2)

Write an SQL query to display customer full names, the car make, model, year and 

amount.

(7)

1.8)

Write a php form to save a name and a picture into the database.

(6)

Answer 1

Dear Precioud, your question requires a lot of work, which neither of our experts is ready to perform for free. We advise you to convert it to a fully qualified order and we will try to help you. Please click the link below to proceed: Submit order