3
votes
2answers
173 views

How to optimize and shorten this SQL query?

I'm doing a sort of exercise where I'm given a question, and I have to answer it by writing a sql query using a database that I was given. This is the question: What is the cheapest fare for a ...
5
votes
4answers
430 views

Database schema for Service Order Management project

I'm a student and I've created this MySQL database schema for my Service Order Management academic project. I want to know if I need to improve it and, if so, how I could do that. ...