![subject](/tpl/images/cats/informatica.png)
Computers and Technology, 28.07.2020 18:01 alexabdercmur
Write an UPDATE statement that modifies the invoice you added in exercise 4. This statement should change the credit_total column so it's 10% of the invoice_total column, and it should change the payment_total column so the sum of the payment_total and credit_total columns are equal to the invoice_total column
UPDATE invoices
SET credit_total = invoice_total * 0.1, payment_total = invoice_total - credit_total
WHERE invoice_id = 115
every time I run this query, I get this error:
1265 Data truncated for column 'credit_total' at row 1 Rows.
![ansver](/tpl/images/cats/User.png)
Answers: 1
![](/tpl/images/ask_question.png)
![](/tpl/images/ask_question_mob.png)
Another question on Computers and Technology
![question](/tpl/images/cats/informatica.png)
Computers and Technology, 22.06.2019 03:10
This program reads a file called 'test.txt'. you are required to write two functions that build a wordlist out of all of the words found in the file and print all of the unique words found in the file. remove punctuations using 'string.punctuation' and 'strip()' before adding words to the wordlist. write a function build_wordlist() that takes a 'file pointer' as an argument and reads the contents, builds the wordlist after removing punctuations, and then returns the wordlist. another function find_unique() will take this wordlist as a parameter and return another wordlist comprising of all unique words found in the wordlist. example: contents of 'test.txt': test file another line in the test file output: ['another', 'file', 'in', 'line', 'test', 'the']
Answers: 1
![question](/tpl/images/cats/informatica.png)
Computers and Technology, 22.06.2019 08:00
What best describes a career pathway in a lodging career? a worker starts out as an amusement attendant, then becomes a recreation worker, and then becomes a gaming worker within five years. a worker starts out as a bell hop, then becomes a night clerk, and then becomes a hotel manager within five years. a worker starting out as a tour guide, then becomes a travel clerk, and then becomes a travel agent within five years. a worker starts out as a server, then becomes a food preparer, and then becomes a head chef within five years.
Answers: 1
![question](/tpl/images/cats/informatica.png)
Computers and Technology, 22.06.2019 10:00
Which of the following is true of operations within a spreadsheet program’s built-in functions? a. operations within parentheses, then multiplication and division, and then addition and subtraction are computed. b. operations within parentheses, then addition and subtraction, and then multiplication and division are computed. c. multiplication and division, then addition and subtraction, and then operations within parentheses are computed. d. addition and subtraction, then multiplication and division, and then operations within parentheses are computed
Answers: 2
![question](/tpl/images/cats/informatica.png)
Computers and Technology, 22.06.2019 19:00
The fourth generation of computers emerged between 1970s and 1980s. which technological advancement brought about this generation of computers? which computer architecture was used most in this generation?
Answers: 3
You know the right answer?
Write an UPDATE statement that modifies the invoice you added in exercise 4. This statement should c...
Questions
![question](/tpl/images/cats/mat.png)
Mathematics, 31.03.2021 17:40
![question](/tpl/images/cats/istoriya.png)
![question](/tpl/images/cats/en.png)
English, 31.03.2021 17:40
![question](/tpl/images/cats/mat.png)
Mathematics, 31.03.2021 17:40
![question](/tpl/images/cats/mat.png)
Mathematics, 31.03.2021 17:40
![question](/tpl/images/cats/mat.png)
Mathematics, 31.03.2021 17:40
![question](/tpl/images/cats/mkx.png)
Arts, 31.03.2021 17:40
![question](/tpl/images/cats/himiya.png)
![question](/tpl/images/cats/biologiya.png)
Biology, 31.03.2021 17:40
![question](/tpl/images/cats/obshestvoznanie.png)
Social Studies, 31.03.2021 17:40
![question](/tpl/images/cats/biologiya.png)
![question](/tpl/images/cats/mat.png)
![question](/tpl/images/cats/istoriya.png)
History, 31.03.2021 17:40
![question](/tpl/images/cats/mat.png)
Mathematics, 31.03.2021 17:40
![question](/tpl/images/cats/geografiya.png)
![question](/tpl/images/cats/mat.png)
Mathematics, 31.03.2021 17:40
![question](/tpl/images/cats/pravo.png)
![question](/tpl/images/cats/fr.png)
French, 31.03.2021 17:40
![question](/tpl/images/cats/mat.png)
![question](/tpl/images/cats/mat.png)
Mathematics, 31.03.2021 17:40