Answer:
Create table vendor(vendor_id int,due_invoice int,invoiceTotal int);
Create view v as select vendor_id,max(due_invoice) as unpaid from vendor;
Select sum(unpaid) from v;
Select vendor_id,invoiceTotal from vendor group by vendor_id;
Answer:
If the following answer is helpful please mark as brainliest. This is the answer:
Explanation:
print("What is your name?")
name=input()
print("And where do you live", name)
location=input()
print("I've never been to", location)
While you’re using the DELETE or UPDATE to change the data in any database like MySQL or ORACLE, the WHERE clause can be used to avoid inadvertently changing data everywhere.
<u>Explanation:</u>
The WHERE clause checks the condition and the changes mentioned by the DELETE or UPDATE command will be done if the condition is true. There are also other clauses like HAVING, IN which will have range either inclusive or exclusive.
It is also noted that in MySQL, there is a method called WorkBench which enables safe mode and doesn’t execute statements without the WHERE clause.
How can you insert a new row into your data without disturbing an adjacent set of data on the same sheet? Highlight only the data where you'd like to insert a row. Right-click > Insert > Shift cells down.
