All categories

2 years ago

Write a SELECT statement that returns these four columns:

1 answer:

3 0

A SELECT command pulls zero or more rows from one or more database tables or views. SELECT is the most often used data manipulation language (DML) command in most applications. See the statement required below.

<h3>What is the SELECT Statement that gives the above results?</h3>

SELECT VendorName, InvoiceNumber, InvoiceDate,

InvoiceTotal - PaymentTotal - CreditTotal AS Balance

FROM Vendors JOIN Invoices

ON Vendors.VendorID = Invoices.VendorID

WHERE InvoiceTotal - PaymentTotal - CreditTotal > 0

ORDER BY VendorName;

Learn more about SELECT Statements at;

brainly.com/question/19338967
#SPJ1

You might be interested in

Two kilograms of air within a piston-cylinder assembly execute a Carnot power cycle with maximun1 and minimum temperatures of 75

ExtremeBDS [4]

Answer:

The Answer and Explanation is in the folloing attachment

Explanation:

8 0

4 years ago

A bar of 75 mm diameter is reduced to 73mm by a cutting tool while cutting orthogonally. If the mean length of the cut chip is 7

barxatty [35]

Answer:

r=0.31

Ф=18.03°

Explanation:

Given that

Diameter of bar before cutting = 75 mm

Diameter of bar after cutting = 73 mm

Mean diameter of bar d= (75+73)/2=74 mm

Mean length of uncut chip = πd

Mean length of uncut chip = π x 74 =232.45 mm

So cutting ratio r

$Cutting\ ratio=\dfrac{Mean\ length\ of cut\ chip}{Mean\ length\ of uncut\ chip}$

$r=\dfrac{73.5}{232.45}$

r=0.31

So the cutting ratio is 0.31.

As we know that shear angle given as

$tan\phi =\dfrac{rcos\alpha }{1-rsin\alpha }$

Now by putting the values

$tan\phi =\dfrac{rcos\alpha }{1-rsin\alpha }$

$tan\phi =\dfrac{0.31cos15 }{1-0.31sin15 }$ \

Ф=18.03°

So the shear angle is 18.03°.

4 0

4 years ago

A small grinding wheel is attached to the shaft of an electric motor which has a rated speed of 3600 rpm. When the power is turn

Ostrovityanka [42]

Answer: a) 150 rev. b) 2105 rev.

Explanation:

a) Assuming a uniformly accelerated motion, we can use the equivalent kinematic equations, replacing linear variables by angular ones.

In order to get the number of revolutions executed, we can use this:

ωf² - ω₀² = 2 γ Δθ (1)

For the first part, we know that ω₀ = 0 (as it starts from rest).

We can find out the value of angular acceleration γ, just applying the definition of angular acceleration, as the change in angular velocity, regarding time, as follows:

γ = (ωf - ω₀) / Δt (2)

As we would want to use SI units, it is advisable to convert the value of ωf, from rpm to rad/sec.

3600 rev/min . (1min/60 sec) . (2π rad/rev) = 120π rad/sec

Replacing in (2), we get γ:

γ = 120 π / 5 rad/sec² = 24 π rad/sec²

Replacing in (1) and solving for Δθ:

Δθ = 120² π² / 2. 24 π = 300 π rad

As 1 rev = 2π rad, Δθ = 150 rev

b) For the second part, we can use exactly the same equations, taking into account that ω₀ = 120 π rad/sec, and that ωf = 0.

The new value for γ is as follows:

γ = -120π / 70 rad/sec² = -1.71 rad/sec²

Replacing in (1) and solving for Δθ, we get:

Δθ = -120² π² / 2. (-1.71) π = 4210 π rad

As 1 rev = 2π rad, Δθ = 2105 rev

7 0

4 years ago

a steel rod of 30mm diameter is enclosed centerally in a hollow copper tube of external diameter 50mm and internal 40mm. the com

masha68 [24]

Answer:

what

Explanation:

6 0

3 years ago

An isolation transformer whose main purpose is to reduce voltage spikes will have a turns ratio of?

garik1379 [7]

Answer:

An isolation transformer whose main purpose is to reduce voltage spikes will have a turns ratio of 1 to 1.

This is due to the windings input and output having the same waveform and amplitude.

6 0

2 years ago