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
Mariana [72]
3 years ago
13

Write SQL queries to answer the following questions: What are the names of the course(s) that student Altvater took during the s

emester I-2018? List the names of the students who have taken at least one course that Professor Collins is qualified to teach. List the names of the students who took at least one course with ""Syst"" in its name during the semester I-2018.

Engineering
1 answer:
amm18123 years ago
6 0

Answer:

See explanations

Explanation:

Consider the following Venn diagram to retrieve the name of course that student Altvater took during semester I-2015.

• In above Venn diagram inner Ellipse represent the subquery part, this subquery part select the Student ID from STUDENT table.

• Second sub query is used to determine the SectionNo of all student whose studentID retrived in the first subquery

• Finally the main query displays the CourseName from COURSE table.

You might be interested in
Write a function named "total_population" that takes a string then a list as parameters where the string represents the name of
adelina 88 [10]

Answer:

Return the total population of all cities in the list.

Explanation:

It is for every element in cityinfo. It works not only for one array but multiple.

I attached the document with the code or function with the name import cvs becuase when I wrote it down and it sent a message written on red about inappropriate words.

Download docx
5 0
3 years ago
1. In a series circuit the sum of all voltage drops produced by the loads in the circuit
GarryVolchara [31]

Answer:

ik the answer but I'm busy rn

5 0
2 years ago
What is a p-n junction? Show by the diagram.
Natalija [7]

Answer:

The p-n junction is a region formed when a p -type semiconductor material is joined to an n-type semiconductor material

Explanation:

The p type semiconductor has holes as its majority charge carriers making it positively charged while the n –types has an overall negative charge. At the junction the holes move towards the electron until such a time when there is a balance in charges from both materials, which leads to the formation of the depletion zone as shown in the attachment below

                           

5 0
3 years ago
PythonA group of statisticians at a local college has asked you to create a set of functionsthat compute the median and mode of
skelet666 [1.2K]

Answer:

  1. def median(l):
  2.    if(len(l) == 0):
  3.       return 0
  4.    else:
  5.        l.sort()
  6.        if(len(l)%2 == 0):
  7.            index = int(len(l)/2)
  8.            mid = (l[index-1] + l[index]) / 2
  9.        else:
  10.            mid = l[len(l)//2]  
  11.        return mid  
  12. def mode(l):
  13.    if(len(l)==0):
  14.        return 0
  15.    mode = max(set(l), key=l.count)
  16.    return mode  
  17. def mean(l):
  18.    if(len(l)==0):
  19.        return 0
  20.    sum = 0
  21.    for x in l:
  22.        sum += x
  23.    mean = sum / len(l)
  24.    return mean
  25. lst = [5, 7, 10, 11, 12, 12, 13, 15, 25, 30, 45, 61]
  26. print(mean(lst))
  27. print(median(lst))
  28. print(mode(lst))

Explanation:

Firstly, we create a median function (Line 1). This function will check if the the length of list is zero and also if it is an even number. If the length is zero (empty list), it return zero (Line 2-3). If it is an even number, it will calculate the median by summing up two middle index values and divide them by two (Line 6-8). Or if the length is an odd, it will simply take the middle index value and return it as output (Line 9-10).

In mode function, after checking the length of list, we use the max function to estimate the maximum count of the item in list (Line 17) and use it as mode.

In mean function,  after checking the length of list,  we create a sum variable and then use a loop to add the item of list to sum (Line 23-25). After the loop, divide sum by the length of list to get the mean (Line 26).

In the main program, we test the three functions using a sample list and we shall get

20.5

12.5

12

3 0
3 years ago
If block A of the pulley system is moving downward at 6 ft>s while block C is moving down at 18 ft>s, determine the relati
kramer

Answer:

Explanation:

The detailed steps and appropriate calculation with analysis is as shown in the attachment.

3 0
2 years ago
Other questions:
  • Air enters a horizontal, constant-diameter heating duct operating at steady state at 290 K, 1 bar, with a volumetric flow rate o
    15·2 answers
  • What is a coarse-grained rock composed of intermediate plagioclase feldspar and pyroxene? a. graniteb. gabbro c. andesited. peri
    9·1 answer
  • Finally you will implement the full Pegasos algorithm. You will be given the same feature matrix and labels array as you were gi
    12·1 answer
  • In order to break even, your minimum selling price must be __________ your variable costs.
    10·1 answer
  • Write a program that asks the user for the name of a file. The program should display the number of words that the file contains
    7·1 answer
  • Who is responsible for conducting a hazard assessment?
    8·1 answer
  • The air standard efficiency ofan Otto cycle compared to diesel cycle for thie given compression ratio is: (a) same (b) less (c)
    12·1 answer
  • Convection ovens operate on the principle of inducing forced convection inside the oven chamber with a fan. A small cake is to b
    6·1 answer
  • What is the purpose of encryption?
    13·1 answer
  • A master stud pattern is laid out somewhat<br> like a?
    8·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!