Hi everyone! I am from Brazil and I would like to ask you for some help, if possible. Please, I need a solution about an SQL select statement. I have a database on mysql administrator. I am attaching an illustration with the entity relationship diagram of my database. I need to make a SQL Select query for it to produce the following result:
- One table which returns the names of the projects of the employee who earns the smallest salary and the employee who earns the biggest salary.
- One table which returns the total number of dependents of the employee who earns the smallest salary and the employee who earns the biggest salary.
I’m sorry if you don’t understand my post, but English is not my first language and here in Brazil we don’t have enough English lessons. Thank you very much for any answers!
the link of database ilustration: https://etecspgov-my.sharepoint.com/:i:/g/personal/alessandra_souza61_etec_sp_gov_br/EQQTKf_ECAtFgI_qHpzjTZEB63hh913gfB-8MP8LqIUDQw?e=DzCR0H