Ask question

Ask question

All categories

3 years ago

10

Write a SELECT statement that returns the same result set as this SELECT statement. Substitute a subquery in a WHERE clause for

the inner join. SELECT DISTINCT VendorName FROM Vendors JOIN Invoices ON Vendors.VendorID = Invoices.VendorID ORDER BY VendorName

1 answer:

sergiy2304 [10]3 years ago

6 0

Answer:

SELECT distinct VendorName FROM Vendors

WHERE VendorID IN (

SELECT VendorID FROM Invoices

)

Explanation:

You might be interested in

Block A has a weight of 8 lb. and block B has a weight of 6 lb. They rest on a surface for which the coefficient of kinetic fric

kkurt [141]

Answer:

For block A, a = 9.66 ft/s²

For block B, a = 15 ft/s²

Explanation:

A free body diagram for this force system is attached to this solution

Mass of block A = m₁ = 8 lb

Mass of block B = m₂ = 6 lb

Coefficient of kinetic friction = μ

Normal reaction on the blocks = N

Spring stiffness of the spring btw block A and B = k = 20 lb/ft

Compression of the spring = 0.2 ft

Analysing Block A first

The forces on block A include, the weight, normal reaction, frictional force and the elastic force due to the spring

Sum of forces in the y-direction = 0

So, the weight of the block = Normal reaction of the surface on the block

N = W = 8 lb

Sum of forces in the x-direction = maₓ

(k × x) - (μ × N) = maₓ

m = W/g = 8/32.2 = 0.248 lbm

(20×0.2) - (0.2 × 8) = (0.248) aₓ

aₓ = 9.66 ft/s²

The forces on block B include, the weight, normal reaction, frictional force and the elastic force due to the spring

Sum of forces in the y-direction = 0

So, the weight of the block = Normal reaction of the surface on the block

N = W = 6 lb

Sum of forces in the x-direction = maₓ

(k × x) - (μ × N) = maₓ

m = W/g = 6/32.2 = 0.186 lbm

(20×0.2) - (0.2 × 6) = (0.186) aₓ

aₓ = 15 ft/s²

4 0

3 years ago

Rosalind franklin<br> What was she famous for

liq [111]

Answer:

She was known for her work on X-ray diffraction images of DNA, which led to the discovery of the DNA double helix for which Francis Crick, James Watson, and Maurice Wilkins shared the Nobel Prize in Physiology or Medicine in 1962.

Explanation:

5 0

3 years ago

It is the tool used to measure the amount of electric current

sergeinik [125]

Answer:

Ammeter

Explanation:

Instrument for measuring either direct or alternating electric current, in amperes. Ammeters vary in their operating principles and accuracies

7 0

3 years ago

Read 2 more answers

What are the relevance of report writing

nasty-shy [4]

Answer:Report writing consists of the history and facts of a project or of any kind of event. It is useful to record past history and an overall summary of decisions. Report writing helps to solve problems as a path. Writing a report will guide you in a way that will modernize details of the improvements and upcoming plans.

6 0

3 years ago

LC3 Programming ProblemUse .BLKW to set up an array of 10 values, starting at memory location x4000, as in lab 4.Now programmati

irga5000 [103]

Answer:

Check the explanation

Explanation:

Code

.ORIG x4000

;load index

LD R1, IND

;increment R1

ADD R1, R1, #1

;store it in ind

ST R1, IND

;Loop to fill the remaining array

TEST LD R1, IND

;load 10

LD R2, NUM

;find tw0\'s complement

NOT R2, R2

ADD R2, R2, #1

;(IND-NUM)

ADD R1, R1, R2

;check (IND-NUM)>=0

BRzp GETELEM

;Get array base

LEA R0, ARRAY

;load index

LD R1, IND

;increment index

ADD R0, R0, R1

;store value in array

STR R1, R0,#0

;increment part

INCR

;Increment index

ADD R1, R1, #1

;store it in index

ST R1, IND

;go to test

BR TEST

;get the 6 in R2

;load base address

GETELEM LEA R0, ARRAY

;Set R1=0

AND R1, R1,#0

;Add R1 with 6

ADD R1, R1, #6

;Get the address

ADD R0, R0, R1

;Load the 6th element into R2

LDR R2, R0,#0

;Display array contents

PRINT

;set R1 = 0

AND R1, R1, #0

;Loop

;Get index

TOP ST R1, IND

;Load num

LD R3,NUM

;Find 2\'s complement

NOT R3, R3

ADD R3, R3,#1

;Find (IND-NUM)

ADD R1, R1,R3

;repeat until (IND-NUM)>=0

BRzp DONE

;load array address

LEA R0, ARRAY

;load index

LD R1, IND

;find address

ADD R3, R0, R1

;load value

LDR R1, R3,#0

;load 0x0030

LD R3, HEX

;convert value to hexadecimal

ADD R0, R1, R3

;display number

OUT

;GEt index

LD R1, IND

;increment index

ADD R1, R1, #1

;go to top

BR TOP

;stop

DONE HALT

;declaring variables

;set limit

NUM .FILL 10

;create array

ARRAY .BLKW 10 #0

;variable for index

IND .FILL 0

;hexadecimal value

HEX .FILL x0030

;stop

.END

7 0

3 years ago