All categories

3 years ago

Write an SQL statement to list the Name of employees who have worked on a property in New York .

Computers and Technology

1 answer:

Savatey [412]3 years ago

7 0

Answer:

Querying a SQL database.

Explanation:

SELECT Last Name, First Name

FROM EMPLOYEE

WHERE Employee ID IN

(SELECT EmployeeID

FROM PROPERTY_SERVICE

WHERE PropertyID IN

(SELECT PropertyID

FROM OWNED_PROPERTY

WHERE City = 'Newyork'));

You might be interested in

Decrypt this message: P ht uva h zwf

KatRina [158]

Translation: I am a spy

5 0

3 years ago

Adjust list by normalizing When analyzing data sets, such as data for human heights or for human weights, a common step is to ad

finlep [7]

Answer:

I've implemented this program using python

userinput = int(input("Length: "))

mylist = []

mylist.append(userinput)

for i in range(1,userinput+1):

userinp = int(input("Input: "))

mylist.append(userinp)

smallval = mylist[1]

for i in range(1,len(mylist)):

if smallval > mylist[i]:

smallval = mylist[i]

for i in range(1,len(mylist)):

mylist[i] = mylist[i] - smallval

for i in range(1,len(mylist)):

print(mylist[i],end=' ')

Explanation:

I've added the full source program as an attachment where I used comments to explain difficult lines

4 0

3 years ago

Read an integer from keyboard and then print the result of the sum obtained by adding the entered integer to the integer formed

Stels [109]

Answer:

Following are the program in C++ language

#include <iostream> // header file

using namespace std; // namespace std;

int main() // main function

{

int number,n1,rem; // variable declaration

int sum,sum1=0;// variable declaration

cout<<"Enter the number :";

cin>>number;// Read the number

n1=number; // initialized the value of number with the n1

while(n1>0) // iteating the while loop

{

rem=n1%10; // finding the reminder

sum1=10*sum1+rem; // storing the sum

n1=n1/10;

}

sum=sum1+number; // calculate the sum

cout<<"The sum is:"<<sum; // Display sum

return 0;

}

Output:

Enter the number :123

The sum is:444

Explanation:

Following are the Description of the Program

Read the value of "number" in the "number" variable of int type .
Initialized the value of "number" in the "n1' variable.
Iterating the while loop until the n1>0.
In this loop we reverse the number in the "sum1" variable
Finally print the sum in the "sum" variable

3 0

3 years ago

Which of the following is an example of new and emerging classes of software?

Rama09 [41]

The answer is Smart technology :)

4 0

3 years ago

Plllzzzzzzzzzzzzzz annnssswweeweerrr...

s2008m [1.1K]

Answer:

An example of effective communication is when the person who you are talking to listens actively and absorbs your point and understands it.

Explanation:

Hope this helps!!

3 0

4 years ago