This pull request includes several updates to the consultas-utiles.sql file, focusing on enhancing existing queries and adding new ones to retrieve sales data.
Improvements to existing queries:
Modified the query to obtain the total number of clients by changing the column names to uppercase for better readability and consistency.
New queries added:
Added a query to retrieve the total sales by type of receipt (TIPO_COMPROBANTE).
Added a query to retrieve the total sales by waiter, including the waiter's first and last name.
This pull request includes several updates to the
consultas-utiles.sqlfile, focusing on enhancing existing queries and adding new ones to retrieve sales data.Improvements to existing queries:
New queries added:
TIPO_COMPROBANTE).