1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
RideAnS [48]
3 years ago
6

write the sql code to generate the total hours worked and the total charges made by all employees . the results are shown in fig

.P7.8
Computers and Technology
1 answer:
luda_lava [24]3 years ago
8 0

Answer:

Select SUM(HOURS), SUM(CHARGES) from employees

Explanation:

The table structure is not given. So, I will assume that the table name is "employees", the columns to retrieve are "hours" and "charges"

Having said that, the function to retrieve the total of column is the sum() function.

So, the query is as follows:

Select ----> This means that the query is to retrieve from the table

SUM(HOURS), SUM(CHARGES) --- This represent the records to retrieve

from employees ---- This represents the table to retrieve from.

You might be interested in
python An instance variable named counter of type int An instance variable named limit of type int. A constructor that takes two
Marianna [84]

Answer:

class Counter:

def __init__(self, counter, limit):

self.counter = counter

self.limit = limit

def increment(self):

if self.counter < self.limit:

self.counter += 1

def decrement(self):

if self.counter > 0:

self.counter -= 1

def get_value(self):

return self.counter

5 0
4 years ago
If you are trying to improve your budget and spending, which option would save you the most money?
Solnce55 [7]

Explanation:

If you want to improve your budget and spending, then the best option that would save you the most money would be buying the securities for a long period of time on fixed basis. This will allow you to hold your savings with the bank, and you won't be able to take them out easily before the term period. In this way you won't think of spending that money. Also you can have an interest amount earned on these securities. In this way you can save the most money.

8 0
3 years ago
Read 2 more answers
How to get someone off your best friends list without blocking them
Paraphin [41]

Answer:

Which website

Explanation:

6 0
3 years ago
Game design colleges anyone know the requirements??
tester [92]
Basic understanding of code language such as Java, C++, Swift (iOS) etc. without knowledge of these, you’ll be lost trust me. Study up on these in your spare time. They do teach this stuff in college, but being ahead of the game is always good. No pun intended kek ;D
8 0
3 years ago
What has been your background with using Windows-based computers?
Radda [10]

Answer:

Anything i desire.

Explanation:

4 0
3 years ago
Read 2 more answers
Other questions:
  • Which term defines a star system with two stars?
    13·2 answers
  • Assume you're using a 3 button mouse. to access shortcut menus, you would
    6·2 answers
  • Which events occurred during the Space Race?
    5·1 answer
  • What effect does the comma style format have on the selected cells?
    13·1 answer
  • What is the unemployment rate if the GDP gap is 13.5%?<br><br> A. 6.25%<br> B. 6.75%<br> C. 6.7%
    8·1 answer
  • Wow, in this century, technology have been the most valuable. What is the worst of using the hi-tech phones
    13·2 answers
  • Fill in the blanks of the SQL Statements: Fund_Id VARCHAR(10) , Donor_id VARCHAR(10) , Count_Of_Receipts INTEGER, Total_Receipts
    15·1 answer
  • A photographer is reading about how to ensure a high-quality photographic print. Which statements convey the best way to ensure
    5·1 answer
  • Adding a border to an image is one way to manipulate media to spice up a project. Where do you find the Picture Styles command t
    15·1 answer
  • From the introductory conversation chip and anna shared, which elements mentioned might suggest the use of case tools?
    13·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!