"Write an SQL query that displays the Ssn and Last name of all employees who is a supervisor of a Department Manager"

Answers

Answer 1

Answer:

SELECT Ssn,

             Last_name

 FROM employees

WHERE position = supervisor;

Explanation:

SELECT is an SQL query statement that is used to initiate the display of wanted variables.

The names of the variables often succeed the SELECT statement and they are separated by commas.

FROM is an SQL query statement that indicates the table fro which the selected variables be displayed.

WHERE is used to filter your search and return only rows that meet the criteria.

; signifies the end of a query and calls for an execution.


Related Questions

What are three reasons developers might choose to use GitHub to work on a
project together?
A. It permits developers to schedule their work calendars, vacation
time, and sick leave around one another.
B. It helps reduce the number of errors in a project and allows
developers to update projects often.
C. It allows developers or the team to review new sections before
they are recombined with the main project.
D. It allows developers to work on a branch or section of code
without affecting the entire project.
SUBMIT

Answers

Answer:

B. It helps reduce the number of errors in a project and allows

developers to update projects often.

C. It allows developers or the team to review new sections before

they are recombined with the main project.

D. It allows developers to work on a branch or section of code

without affecting the entire project.

Developers might choose to use GitHub to work on a project together because it allows them to:

A. Reduce errors in a project and update it frequently.

C. Review new sections before recombining them with the main project.

D. Work on a branch or section of code without affecting the entire project.

Therefore, options A, C, and D are correct.

GitHub is a web-based platform that serves as a collaborative sanctuary for software developers, akin to an interconnected digital realm. It empowers developers to host, review, and manage code repositories, fostering seamless teamwork and version control.

This virtual sanctuary functions as a haven where developers can contribute to projects, propose changes, and work collectively without disrupting the main codebase.

With its versatile tools, GitHub offers a captivating arena for developers to explore, collaborate, and unleash the full potential of their projects in a harmonious symphony of coding brilliance.

Therefore, options A, C, and D are correct.

Learn more about GitHub here:

https://brainly.com/question/30911741

#SPJ7

Which of the following expressions evaluate to 3.5

Answers

Answer: Some expressions equal to 3.5 are 7/2, 3.50, etc

Suppose that you have created a program with only the following variables
Int age=34
Int weight =180
Double height =5.9
Suppose that you also have a method with the following header:
Public static void calculate (Int age, double size)

Which of the following methods calls are legal and why
Calculate (age, height)
Calculate (weight, weight)

Answers

Explanation:

Calculate (age, height) is legal because method's second argument (double size), needs double value.

Using the print() function, output, "Let's play Silly Sentences!"
Using the input() function, prompt the user to, "Enter a name: ", then assign and store their response to a variable.
Repeat benchmark 2 for the other 8 inputs that we need from the user: adjective, adjective, adverb, food, food, noun, place, and verb.
Using a print() function, output, "[name] was planning a dream vacation to [place]." Replace [name] and [place] with the proper variables.
Repeat step 4 with the other 6 lines of output.
Double-check to make sure the output is formatted correctly - including spaces before and after variables and line spacing.
Run and test your program with the values from the Sample Run.
Debug and repeat step 7 as needed.

Answers

Answer:

print("Let's play Silly Sentences!")

name = input("Enter a name: ")

adjective1 = input("Enter a adjective: ")

adjective2 = input("Enter a adj: ")

adverb = input("Enter a adverb: ")

food1 = input("Enter a food: ")

food2 = input("Enter another food: ")

noun = input("Enter a noun: ")

place = input("Enter a place: ")

verb = input("Enter a verb: ")

print( "\n" + name + " was planning a dream vacation to "+ place + "." )

print( name + " was especially looking forward to trying the local \ncuisine, including " + adjective1 + " " + food1 + " and " + food2 + ".")

print("\n" + name + " will have to practice the language " + adverb + " to \nmake it easier to " + verb + " with people.")

print("\n" + name + " has a long list of sights to see, including the\n" + noun + " museum and the " + adjective2 + " park.")

Which is an advantage of Cloud Computing?

Answers

One advantage that cloud computing has is allowing us to pick up information easily. With cloud computing you can deploy your application in multiple regions in no time with a few clicks.

PLEASE HELP
Which of these would a computer scientist study, in addition to computers?

grammar
grammar

graphics
graphics

biology
biology

math
math

Answers

In addition to computers, a subject which a computer scientist would most likely study is: D. math.

What is a computer?

A computer can be defined as an electronic device that is designed and developed to receive data in its raw form as an input and it processes these data into an output (information), which can be used to perform a specific task through the use of the following computer parts:

KeyboardNetworkMonitor screenMouseHard-disk drive

Who is a computer scientist?

A computer scientist can be defined as a professional who has been trained to specialize in the study of the theoretical aspect of computers, including analyzing and reviewing algorithmic computations, programs or codes.

In this context, we can reasonably infer and logically deduce that in addition to computers, a subject which a computer scientist would most likely study is math.

Read more on computer scientist here: https://brainly.com/question/22495842

#SPJ1

Please help me this goes with computer science so yeah

Answers

In today's world, the electronic version of the above can be sent as an ecard via any standard email service provider instantly over the internet.

How can the sender and receiver achieve the above?

In order for the above to be possible today, the sender must have have an electronic mail address which is referenced to a domain name. The same goes to the receiver.

It is to be noted that the data (in this case the text and pictures contained int he postcard) are delivered to user accounts across several computer servers.

The computer servers transport the messages to their final destination and store them so that users may retrieve and send them whenever they connect to the email infrastructure. An email client or a web interface can be used to access email.

What are the comparisons?

While there is a feeling that comes with handling physical mail such as the advantage of having the card retrieved without electricity, the ability to create handcrafted art, and even perfumed cards, they took relatively too long to prepare and to be sent to receiver.

Unlike traditional mail, electronic postcards are can be created, customized and sent withing a minute. E-post cards, unlike traditional ones, can be automated and sent to million of people at the same time in an instant.

Learn more about postcards:
https://brainly.com/question/15435088
#SPJ1

vvcccccccccccccccccccccccvcvcvcvcvcvcvvcvc

Answers

Answer:

Ok then..lol What does that even mean?

Audra is creating a training document and would like to include an image that she sees on her screen that she has marked up for training purposes.

Which options should Audra use?

Insert tab, Pictures
Insert tab, Screenshot
Insert tab, Online Images
Insert tab, Format

Answers

Answer:

insert scrnshot

Explanation:

because she probably wants to include the marks

Can you help me answer this?​

Answers

explaination: 

The use of 1.self-reflection by students helps them better understanding of the learning,


with the improvement in the test performance, and the analysis of the subject 


2.they need help in. Thus, option and are correct.What is self-reflection?Self reflection is given as self assessment that mediates the development of the individual with his own assessments of the strength and the weakness.The self-reflection by students help them analyze their code and command over a subject and thereby forms the development of the better understanding of the learning, with the improvement in the test performance, and the analysis of the subject they need help in. Thus, option 

In a paragraph or two, discuss the similarities and differences between NTFS, Share, and Linux permissions..

Answers

The similarity between NTFS Share and Linux permissions is that they change the access permissions.

The difference is that NTFS permissions allow you to provide users with more granular access while share permissions are easier to manage and apply.

How to illustrate the information?

Share permissions do not apply to users who are logged in locally to the server, but NTFS permissions do. Share permissions, as opposed to NTFS permissions, let you limit the number of active connections to a shared folder. Share permissions are set up in the "Permissions" settings' "Advanced Sharing" properties.

The most restrictive permission will take precedence over the others if you employ NTFS permissions and sharing permissions simultaneously. The user will only be able to read the file or have a look at the things in the folder, for instance, if NTFS share permissions are set to Full Control but share permissions are set to "Read."

In conclusion, NTFS permissions allow you to provide users more granular access while share permissions are easier to manage and apply.

Learn more about Linux on:

https://brainly.com/question/25480553

#SPJ1

All of the fallowing are statements describing normal mechanical fan clutch operation EXCEPT:

Answers

The statements above are describing normal mechanical fan clutch operation except D. A fan clutch varies fan speed according to engine speed.

Why the above option chosen?

A properly functioning or operating fan clutch will be one that alter  the speed of the fan based on the engine temperature.

Not that if the engine is cold, the fan clutch is one that has no power to turn the fan very fast, even if engine speed is brought up. As the engine warms up, the fan clutch goes up on the speed of the fan.

Therefore, based on the above, The statements above are describing normal mechanical fan clutch operation except D. A fan clutch varies fan speed according to engine speed.

Learn more about clutch from

https://brainly.com/question/13262716

#SPJ1

All of the following are statements describing normal mechanical fan clutch operation EXCEPT:

A. A fan clutch has viscous drag regardless of temperature.

B. A fan clutch varies fan speed according to engine temperature.

C. A fan clutch stops the fan from spinning within two seconds after turning off a hot engine.

D. A fan clutch varies fan speed according to engine speed.

2. Define what is a Flowchart and Algorithm?​

Answers

Answer:

an algorithm is a specific set of instrucions or rules for carrying out a procedure or solving a particular problem.

flow chart is a symbolic representation of an algorithm.

Write five examples of products that are needed in your school ​

Answers

1. Pencil/pen
2. Paper/ notebooks
3. Calculator
4. Folders/binders
5. Erasers

this is confusing and need help so please help me right now

Answers

In order to round a given number to n decimal places in Java, you would use two methods and they are:

Round a Number using format

public class Decimal {

  public static void main(String[] args) {

       double num = 1.34567;

       System.out.format("%.4f", num);

   }

}

Round a Number using DecimalFormat

import java.math.RoundingMode;

import java.text.D ec im al Fo rmat;

public class Decimal {

  public static void main(String[] args) {

       double num = 1.34567;

       DecimalFormat df = new DecimalFormat("#.###");

       df.setRoundingMode(RoundingMode.CEILING);

       System.out.println(df.format(num));

   }

}

Read more about programming here:

https://brainly.com/question/23275071

#SPJ1

mention the four categorie of ammation

Answers

2D animation
3D animation
Stop motion animation
Motion graphics

what coder does assembly language use for programming?

Answers

Answer:

These short codes are converted into machine learning language (binary, i.e., 1s and 0s) through the use of programs called assemblers. In a nutshell, machine language uses binary code, which is almost impossible for humans to decipher, whereas assembly language uses mnemonic codes to write a program.

JAVA: People find it easier to read time in hours, minutes, and seconds rather than just seconds. Write a program that reads in seconds as input, and outputs the time in hours, minutes, and seconds. Ex: If the input is: 4000 the output is: Hours: 1 Minutes: 6 Seconds: 40

Answers

Hope this helps mate

I need a Java program that handles the order list for if I were an online retailer. The program should contain a minimum of three classes:
Order Class
Display Class
Main Class
The Order Class that uses a queue to hold the orders in the order they were taken, and the queue should contain the customer's last name, order number, and order total cost. The Display Class needs to store a copy of the order queue in two arrays. Each array will contain the order list, but one will be sorted by name and the other sorted by order number. When an order is taken and stored in the Order Class the program will update the Display Class arrays automatically and sort them in descending order using quick sort and outputs the contents to the console upon each entry of new data.


There should be a Main Class that will handle operator data input and when an order is added or removed, the program will update the Order Class and Display Class. The end-user should be presented with a menu to add an order, remove an order and display the order list from the queue.

Answers

Using the knowledge in computational language in JAVA it is possible to write a code that  handles the order list for if I were an online retailer.

Writting the code:

import java.lang.*;

import java.util.*;

class Fruit{

private String fruit_name;

private double tot_weights;

private double price;

public const static String fruit_nvalue="?";

public const static double def_value=0.0;

public Fruit(){

 fruit_name=fruit_nvalue;

 tot_weights=price=def_value;

}

public Fruit(String fruit_name,double tot_weights,double price){

 this.fruit_name=fruit_name;

 this.tot_weights=tot_weights;

 this.price=price;

}

public double order(double order_weights){

 if(order_weights>tot_weights){

  return double(-1);

 }

 else{

  tot_weights=tot_weights - order_weights;

  return order_weights*price;

 }

}

public Boolean equals(String fruit1,double wei1,double price1,String fruit2,double wei2,double price2){

 if(((fruit1.equals(fruit2)) &&(wei1==wei2) && (price1==price2))== true ){

  return true

 }

}

public String toString(){

 return fruit_name+" "+tot_weights+" "+price;

}

}

class OnlineSuperMarket{

private Fruit[] fruit_objects;

private String store_name;

private String web_address;

public const static float tax_rate = 0.095;

public const static int size=10;

public const static sn="TBD";

public const static wa="www.unknown.com";

Scanner scan=new Scanner(System.in);

public OnlineSuperMarket(){

 fruit_objects=new Fruit[size];

 store_name = sn;

 web_address = wa;

}

public OnlineSuperMarket(String store_name,String web_address){

 this.store_name=store_name;

 this.web_address=web_address;

 fruit_objects=new Fruit[size];

}

public void init(){

 String fruit_names[];

 double weights[];

 double prices[];

 

 for(int i=0;i<fruit_objects.length;i++){

  fruit_objects[i]=new Fruit(scan.next(),scan.nextDouble(),scan.nextDouble());

 }

}

public void sort(){

 Arrays.sort(fruit_objects);

}

public void run(){

 while(true){

  System.out.println(" Enter a fruit name or Q (or q) to end:");

  String choice= scan.next();

  if(choice = "Q" || choice = "q"){

   quit();

  }

  else{

   if(find(choice)){

    System.out.println("Enter weight in lbs:");

    double weight=new nextDouble();

    double price = order(weight);

    if(price == double(-1)){

     System.out.println("quantity not available");

    }

    else{

     total_cost = price+tax_rate;

     System.out.println("You ordered");

     System.out.println("Fruit: "+choice);

     System.out.println("Weight: "+weight+" lbs");

     System.out.println("Price: "+price+"/lbs");

     System.out.println("Total cost (plus tax): $"+total_cost);

    }

   }

   else{

    System.out.println(choice+" not available");

   }

  }

 }

}

public void showFruits(){

 for(Fruit obj:fruit_objects){

  System.out.println(obj.toString());

 }

}

public void quit(){

 showFruits();

 System.out.println("Thanks for your visit. Please come again!");

 System.exit();

}

public Boolean find(Strign fruit_name){

 sort();

 int first=0;

 int last = fruit_objects.length;

 int mid = (first + last)/2;  

    while( first <= last ){  

       if (fruit_objects[mid] < fruit_name ){  

         first = mid + 1;    

       }else if ( fruit_objects[mid].equals(fruit_name) ){  

         return true;  

         break;  

       }else{  

          last = mid - 1;  

       }  

       mid = (first + last)/2;  

    }  

    if ( first > last ){  

       return false;

    }  

}

}

public class Design{

public static void main(String[] args) {

 OnlineSuperMarket osm=null;

 osm = new OnlineSuperMarket(store_name, web_address);

 init();

 showFruits();

 sort();

 showFruits();

}

}

See more about JAVA at brainly.com/question/12975450

#SPJ1

What is output by the following program?
def sample (val):
val = val - 8
#MAIN
n = 16
sample (n)
print (n)

Answers

Explanation:

I don't know what language this is, but the functions (methods) should work the same. It should change the value of n by decreasing it by 8 so the solution would be 8.

The functions (methods) should work the same. It should change the value of n by decreasing it by 8 so the solution would be 8.

When the program is to be printed?

The first, print(val) will be printed, and here the value of val is 25 as set outside the function. Then the print(val) inside the example() will be printed, and here we have declared val as global and set its value to 15, And with last print as well, since the val is now global and with value 15, and hence the output will be 15. And hence the output is as above.

The execution of the program in the "for" loop  will be following

For k=0

=> val=1 and sum=0+1=1

For k=1

=> val=2 and sum=1+2=3

For k=2

=> val=3 and sum=3+3=6

For k=3

=> val=4 and sum=6+4=10

For k=4

=> val 5 and sum=10+5=15

For k=5

=> val=6 and sum=15+6=21

For k=6

=> val =7 and sum=21+7=28

For k=7

=> val=8 and sum=28+8=36

For k=8

val=9 and sum=36+9=45

So, all the iterations of for loop are completed and the output is 45.

Therefore, The functions (methods) should work the same. It should change the value of n by decreasing it by 8 so the solution would be 8.

Learn more about functions on:

https://brainly.com/question/12431044

#SPJ2

What are the key features of knack

Answers

Answer:

User Access. Secure access for your users to manage their data.

Workflow & Automation. The right data for the right users at the right time.

Data Management. A single platform to collect, manage, and audit your data.

Reports & Dashboards. Realtime charts and formulas to report on your data.

Payments. ...

Integrations.

Explanation:

Assuming there are 7.481 gallons in a cubic foot. Write a program that asks the user to enter a number of gallons, and then displays the equivalent in cubic feet.


The program must use assignment operators, cout’s, cin’s, and declaration of variables.

Answers

Using the knowledge in computational language in C++ it is possible to write a code that asks the user to enter a number of gallons.

Writting the code:

#include <iostream>

using namespace std;

int main()

{

      float gallons, cufeet;

      cout << "\nEnter quantity in gallons : ";

      cin >> gallons;

      cufeet = gallons / 7.481;

      cout << "Equivalent in cublic feet is " << cufeet << endl;

      return 0;

}

See more about C++ at brainly.com/question/19705654

#SPJ1

Describe your Johari Window. Which area or areas are largest for you? Smallest?

Answers

The windows you have in full screen are the largest, the smallest ones are the ones you have hidden and are not shown in the taskbar


Identify and describe your computer or laptop's hardware, software, and operating system.

Answers

Explanation:

Computer hardware is any physical device used in or with your machine, whereas software is a collection of programming code installed on your computer's hard drive. In other words, hardware is a product you can hold in your hand, whereas software cannot be held in your hand.

The Hardware have the parts as: Central Processing Unit , Random Access Memory , Disk Drive and Motherboard.Software refers to the programs and applications that run on a computer system.

Hardware:

A computer or laptop typically consists of various hardware components, including:

1. Central Processing Unit (CPU): This is the main processing unit of a computer responsible for executing instructions and performing calculations.

2. Random Access Memory (RAM): It provides temporary storage for data and instructions that the CPU can access quickly.

3. Solid State Drive (SSD): These are storage devices for long-term data storage, including the operating system, software programs, and user files.

4. Motherboard: It connects and allows communication between various components of a computer, such as the CPU, RAM, and storage devices.

Software:

Software refers to the programs and applications that run on a computer system.

Some common types of software include:

1. Operating System (OS): It manages the computer's hardware and software resources, providing a user interface and enabling users to interact with the system.

2. Applications: These are software programs designed to perform specific tasks, such as word processing, web browsing, photo editing, or video playback.

Operating System:

An operating system is the software that manages computer hardware and software resources and provides a platform for running applications.

Learn more about Operating System here:

https://brainly.com/question/33924668

#SPJ4

HELP HELP HELP Help Helpl

Answers

Answer:

#include <stdio.h>

int main(void) {

 float number = 0;

 printf("Enter a number: ");

 scanf("%f", &number);

 

 number *= 2;

 printf("The number doubled is: %f\n", number);

 return 0;

}

Explanation:

Assuming you want a C program, see above.

What are the three major areas in the data warehouse? Is this a logical division? If so, why do you think so? Relate the architectural components to the three major areas

Answers

The three major areas in the data warehouse are:

The enterprise data warehouse (EDW).The operational data store (ODS).The data mart.

Yea, this is logical division because it helps to give room for viewing data without any form of transformation or movement.

What is a Data Warehouse?

A data warehouse is known to be a term that connote a form of a central keep hold of information that can be examined to be able to make a lot of informed decisions.

Note that this is one where Data tend to flows into a data warehouse through the kind of transactional systems, relational databases, as well as other sources.

Since Data Warehousing make use of data and information obtained from a lot of  sources into a single comprehensive database. Therefore, The three major areas in the data warehouse are:

The enterprise data warehouse (EDW).The operational data store (ODS).The data mart.

Learn more about data warehouse from

https://brainly.com/question/28166807

#SPJ1

An/a ___________ is the security role responsible for providing oversight within an organization to ensure policy compliance.

Answers:
Custodian

Auditor

User

Manager

Answers

I think it’s either manager or custodian

Write an expression to print each price in stock_prices.

Answers

Answer:

This cannot be answered unless context is given. Comment your programming language and code written.

Where is the hard drive located

Answers

Answer:

The hard drive is located in the drive bay.

In your pc duhhhhhhh

What is a catch memory

Answers

Cache memory

Explanation:

A cache is a high-speed data storage layer which stores a subset of data, typically transient in nature, so that future requests for that data are served up faster than is possible by accessing the data's primary storage location

Other Questions
Read the excerpt from Immigrant Kids by Russell Freedman.Men, women, and children were packed into dark, foul-smelling compartments. They slept in narrow punks stacked three high. They had no showers, no lounges, and no dining rooms. Food served from huge kettles were dished into dinner pails provided by the steamship company . . .The voyage was an ordeal, but it was worth it. . . .Edward Corsi, who later became United States Commissioner of Immigration, was a ten-year-old Italian immigrant when he sailed into New York harbor in 1907:"My first impressions of the New World will always remain etched in my memory, particularly that hazy October morning when I first saw Ellis Island. The steamer Florida, fourteen days out of Naples, filled to capacity with 1600 natives of Italy, had weathered one of the worst storms in our captains memory; and glad we were, both children and grown-ups, to leave the open sea and come at last through the Narrows into the Bay.My mother, my stepfather, my brother Giuseppe, and my two sisters, Liberta and Helvetia, all of us together, happy that we had come through the storm safely, clustered on the foredeck for fear of separation and looked with wonder on this miraculous land of our dreams."According to the passage, the voyage was difficult, but worthwhile. How does the quotation from Edward Corsi develop this topic?It provides a firsthand experience from an immigrant who says he clustered on the foredeck for fear of separation.It provides a firsthand experience from an immigrant who says his first impressions of the New World will always remain.It provides a firsthand experience from an immigrant who says he was happy to come to this miraculous land of our dreams.It provides a firsthand experience from an immigrant who says the boat was filled to capacity with 1600 natives of Italy. How do you think the density of two pieces of gold, one small and one large, would compare? Put the images below according to the sequence that the solar system formed. The last one is done for you. the romantic quality of his work made him one of the most beloved and successful artists of the nineteenth century How would fat based cell membranes be a benefit to cells? for each of the following goods that are imported in the united states, identify which of the three sources of comparative advantage (abundant inputs, specialized skills, or mass production) accounts for that country's comparative advantage. Write me a 150 word prompt pleaseAbout Monsters in our communities. What equation is equivalent to the equation 5x + 30 = 45? Which of the following is an element?A. MethaneB. OzoneC. IceD. Air lululemon sells high-end workout clothing. people are willing to pay high prices because of the clothing styles and the customer service received. these stores use . Select a number to make the following statement true.0.07 is 10 times as great as A. 0.1B. 0.7C. 0.001D. 0.007 identify two pieces of evidence from the map that reflect the English motives for colonization insecticide resistance if the frequency of a gene for insecticide resistance is (a constant), then its frequency in the next generation is given by the expression how and why does the development of language illustrate the importance of culture and provide evidence for the sociological perspective? minimum length 1 page (250 words). the graph of the parabola y=1/4(x+2)^2-6 is shown on the coordinate plane below according to the graph for which values of x is y always positive ? How are pigs being genetically modified to help humans? Solve pls brainliest list and describe the three variables of freshwater habitats that are different from variables that affect land habitats. Because most particles fired at metal foil passed straight through, rutherford concluded that. 43.3(blank) subtract 12.82 Im giving off 20 points for this