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
Alika [10]
3 years ago
8

Write a SQL statement to display course name, course number, and the average capacity of all sectionsof each course, rounded to

four decimal places, where students are enrolled, and the average capacityis less than twenty five (use a correlated sub-query and use a column alias of AVERAGECAPACITY torepresent the number.
Computers and Technology
1 answer:
icang [17]3 years ago
8 0

Answer:

SELECT C. DESCRIPTION, C. COURSE_NO, ROUND(AVG(CAPACITY), 4) AS AVERAGECAPACITY

FROM COURSE C, SECTION S

WHERE C. COURSE_NO = S. COURSE_NO

GROUP BY C. COURSE_NO

HAVING AVG(CAPACITY)<25

You might be interested in
Write biggerDigits.cpp that has a function called biggerDigits that uses two positive integer parameters with the same number of
fomenos

Answer:

Following are the program in the C++ Programming Language:

#include <iostream> //header file

using namespace std; //namespace

int biggerDigits(int n, int m) { //define function

if (n <= 0 || m <= 0) { //set if statement

return 0;  

}  

else { //set else statement

int a,b; //set integer variables

a = n % 10; //perform modulatio  

b = m % 10; //perform modulatio

int max = a; //set integer variable and assign value  

if (b > max) //set if statement

max = b; //initialize value to max

/*solution is here*/

return 10 * biggerDigits(n / 10, m / 10) + max;

}

}

int main() // main method  

{ // code is refer from question to make the program

cout << biggerDigits(567, 765) << endl; // call the function biggerdigits

cout << biggerDigits(123456, 444444) << endl; // call the function biggerdigits

//call function and print result

cout << biggerDigits(999, 111) << endl; // call the function biggerdigits

return 0; // return the integer 0

}

Explanation:

Here, we set the header file "<iostream>" and namespace "std" then, we set a function "biggerDigits()" and pass two integer type arguments inside it.

  • we set if condition in which when the variable "n" is less than equal to 0 or m is less than equal to 0 then, it return 0.
  • we set the else statement inside it we set two integer type variables "a" and "b" then, perform modulation with both the variables.
  • we set integer variable "max" and assign value of a in it.
  • we set if condition in which we check when the variable b is greater than variable max then, initialize the value of variable b in the variable max and return the solution through recursion.
7 0
3 years ago
Namedroppers is a tool that can be used to capture Web server information and vulnerabilities in a Web site's pages that could a
Alexxx [7]

Answer:

False

Explanation:

Namedroppers help you look for domain names that are constantly updated on a daily basis. You can purchase a domain name of your choice from the results of the available domain names that are populated by namedropper. The description from the question above belongs to web application vulnerability scanners. These scanners are automated to scan web apps and look for vulnerabilities that most attackers take advantage of like SQL injection and buffer overflows.

8 0
4 years ago
(choose one) Which is the proper means to decrement the integer variable, myScore, by one?
kakasveta [241]

Answer

                                                                                                                                                                                                         

Explanation

its too short please add more characters

7 0
3 years ago
Which of these is a significant reason why social change has taken place in the past 100 years?
agasfer [191]
C, because technology has changed our social life by texting and messaging.
Hope this helps
8 0
3 years ago
What is the lowest layer of the OSI model at which LANs and WANs support the same protocols?
Komok [63]

Answer: Layer 3

Explanation:

The layer 3 in OSI model is the network layer which is responsible for routing the packet across the network.

So we need a switch and a router for the LAN and WAN connection and both of them has to support the same protocols at layer 3.

3 0
3 years ago
Other questions:
  • You have been asked to create an authentication security plan for your company. Which of the following components would you inco
    14·1 answer
  • Your friend is working on fixing their Homework assignment. They need a lot of help. You know all the bugs in the file, but due
    12·1 answer
  • Greg works for an online games development company. He is not a net freak, but occasionally he visits online literature sites an
    7·1 answer
  • 14. What significant contribution did Gutenberg make to the printing process?
    11·2 answers
  • What is an algorithm? An executable file that has been converted into machine language A set of markup instructions A set of ins
    6·1 answer
  • Programmers compile a list of instructions to build their applications. These instructions are typically grouped into units of c
    10·1 answer
  • The central computer on a network is called the ______. A) boss B) client C) parent D) server
    11·2 answers
  • PLEASE HELP!!!
    11·2 answers
  • Donna often travels around the world. When she travels, she needs to access her emails from different locations. However, to kee
    7·2 answers
  • A list cannot use appendleft but a _____ can.
    11·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!