Question

Silvia gasta la mitad de su paga en el cine y un sexto en golosinas. Si todavía le quedan 4 €, ¿cuánto le han dado de paga?
PORFAAAA

Answer 1

Answer:

paga = x

gato en cine =x/2

gatsto en golosinas =x/6

le quedan 4€

x = x/2 +x/6 +4 el mcm de 2y 6 es 6

x= (3x+x+24)/6

6x = 4x+24

6x-4x = 24

2x = 24

x = 24/2

x = 12

le pagaron 12€

prueba

x = x/2 +x/6 +4

12 =12/2 +12/6 +4

12 = 6+2+4

12 = 12

Answer 2

Answer:

Write the SQL statements to find each of the followings: 1. Clients who do not have any payments. 2. Invoices with no payments. 3. Create a view that contains: InvNo, date, amt, payNo, date, amount, for invoices with and without payments, and payments with or without invoices. 1. Write the function "ClientBalance", which returns the difference between total invoice amount and total payment amount for a given client. 2. List of clients with their Balance, in case their balance is over 10000. 3. Write the previous function as a procedure. 4. Write the necessary triggers that update balance when a new invoice or payment is made by a client.