6. Write SQL statement to show all parts with cost between 10 and 50. 7. Write...

 

Transcribed Image Text:

6. Write SQL statement to show all parts with cost between 10 and 50. 7. Write SQL statement to show all the repairs that were performed in March 2022. 8. Write SQL statement to show for each Customer ID, the number of repairs he placed with the company. Show the records in ascending order of Customer ID. 9. Write SQL statement to show for each Service the total cost of all Parts used in that Service. 10. Write SQL statement to show for each repair the number of Services performed for that repair and the total cost for all parts for that repair (including all services). 6. Write SQL statement to show all parts with cost between 10 and 50. 7. Write SQL statement to show all the repairs that were performed in March 2022. 8. Write SQL statement to show for each Customer ID, the number of repairs he placed with the company. Show the records in ascending order of Customer ID. 9. Write SQL statement to show for each Service the total cost of all Parts used in that Service. 10. Write SQL statement to show for each repair the number of Services performed for that repair and the total cost for all parts for that repair (including all services).