solution Please write a sample query to look at data by week for the created_at date, where you're summing revenue by country and state.

Answers

Answer 1
SELECT QUERY is used for the MySQL database fetching. It chooses is planned to return 1 or more rows from the database tables which meet a given criterion. It could be used for PHP, Ruby, and you can execute them via the command prompt inside the scripting language, and further queries can be defined as follows:

Following are the complete Query to this question:

SELECT  DATEPART(week, created_at) AS Week,  Sum(revenue) AS Revenue  FROM country  WHERE '20180101' <= created_at  AND created_at < '20190101'  GROUP BY DATEPART(week, created_at)  ORDER BY DATEPART(week, created_at);

Learn more:

brainly.com/question/22044117

brainly.com/question/11771506


Related Questions

how do we use electricity?

Answers

Answer:

People use electricity for lighting, heating, cooling, and refrigeration and for operating appliances, computers, electronics, machinery, and public transportation systems.

Answer:

People use electricity for lighting, heating, cooling, and refrigeration and for operating appliances, computers, electronics, machinery, and public transportation systems.

mark me a brainlist

List the resulting array after each iteration of the outer loop of the selection sort algorithm. Indicate the number of character-to-character comparisons made for each iteration (line 07 of the Selection Sort algorithm). Sort the following array of characters (sort into alphabetical order): C Q R B P D X.
public static void selectionSort (char[] a){
int n = a.length;
for (int i = 0; i < n; i++){
int min = i;
for (int j = i + 1; j < n; j++){
if (a[j] < a[min]){
min = j;
}
}
exchange(a, i, min);
}
}
private static void exchange(char[] a, int i, int j){
//exchange the value at index i with the value at index j
char temp = a[i];
a[i] = a[j];
a[j] = temp;
}

Answers

Answer:

$5+879+$431=$426809800

In a Linux interface configuration file, the ONBOOT parameter indicates whether or not the interface is a boot device.

a. True
b. False

Answers

I think it is false

Which of these was the first era of computing concerned with? Choose one

1. Computation

2. Communication

3. Electronic commerce ​

Answers

1. Computation

Answer

1.John Von Neumann's architecture model was proposed not only to staire data but to also execute instructions

Which network would provide you with the most security and control to automatically backup data

Answers

Centralized
Client server
GUI
Peer-to-peer

Type two statements. The first reads user input into person_name. The second reads user input into person_age. Use the int() function to convert person_age into an integer.

Answers

Answer:

brainliest

Explanation:

What is the value of total returned by the call secret(3) ? int secret int num) { int total= 10; switch(num) { case 1: case 2: total=5. break case 3. total= 10: case 4: total=total+3: case 8: total=total+6. break default: total=total+ 4. break} return total; }​

Answers

Answer:

19

Explanation:

Without break; statements, the switch "falls through" to the next case. So the code is directed to case 3, which sets total to 10. Then another 3 gets added and another 6, because cases 4 and 8 are also executed. That brings the total to 19.

So, always use a compile rule or code checker that checks your code for missing breaks, because it is hardly ever what you want on purpose.

In java.Find the output of the expressions i) 3 % 4 ii) 3 / 4​

Answers

Answer:

the odd one is 3%4

Explanation:

3% means 3/100 and there is 4beside it

1. The most common cause of a stuck accelerator is the
A. engine
B. steering wheel
C. brakes
D. floor mat

Answers

D. Floor mat. Floor mats are dangerous because they can slip, wedging the accelerator.

Answer:

D: Floor Mat

Explanation:

The floor mat can easily get flipped up onto either the breaks or the gas pedal, causing your car to malfunction.

1. What kind of metrics would be useful that are based on testing knowledge after security awareness training? The metrics could be obtained immediately after training or at periodic intervals over several months.

Answers

Answer:

i hope it will helpful for your

mark me brainlist

Explanation:

Metrics refer to a system or standards of measurement.

These are measures of quantitative assessment for the purpose of comparing, tracking and performance measurement.

When it comes to measuring employee's awareness, people's knowledge of comprehensive security awareness it can be monitored through online security awareness programs. The knowledge of the employees can be tested in regard of a hot topic i.e cybersecurity practices.

Online quizes can be used to show whether employees know the risks of leaving a computer unmonitored.

Simulated or planned cyber attacks, mockdrills can be planned by the company to test the presence of mind, readiness of employees after the training.

These things should be done without any prior notice so that the employees feel the real pressure and the situation is same as the real world

The metrics used to test the security awareness of the trained staff must be consistent, cheap to gather, can be expressed as cardinal or in percentage , and most importantly they should be contextually relevant i.e they should faciliate decision makers to take actions and attain the desired objective.

Awareness surveys are important baseline to test the knowledge of employees after the training. They are simple to set up and easy to use as well.

For example- all employees know that there is a security team but do they know their goals and policies of the team. Awareness surveys can be used to check these parameters and get the desired results from it.

Online security awareness programs may be used to track people's understanding of complete security awareness.

What are metrics?

The metrics used to assess the security awareness of the trained staff must be reliable, inexpensive to collect, expressed as a percentage or as a cardinal value, and most importantly, contextually relevant—that is, they must make it easier for decision-makers to take action and accomplish their goals.

As we know, online security awareness programs may be used to track people's understanding of complete security awareness when it comes to gauging employee awareness.

Employee expertise in relation to a current issue, such as cybersecurity procedures, can be evaluated.

Thus, online security awareness programs may be used to track people's understanding of complete security awareness.

Learn more about the matrices here:

https://brainly.com/question/15823780

#SPJ2

Explain 5 different types of HTML tags and give examples.​

Answers

Answer:

Tag Description

<header> It defines a header for a section.

<main> It defines the main content of a document.

<mark> It specifies the marked or highlighted content.

<menuitem> It defines a command that the user can invoke from a popup menu

Need help coding this

Answers

Answer:

read the hint

Explanation:

ur missing something

which is true about artificial intelligence? a) can think b) act as body c) act as brain d) can learn.

Answers

Answer:

c). act as brain.

Explanation:

brain thinks and learns, so it covers a and d

[tex].[/tex]

C- act as brain
Reason: because a A.I. Can’t really learn if it’s programmed for a specific function and can’t act as a body if there programmed to do something they don’t really think in the process if it’s all 1’s and 0’s they just do what there told unless there programmed to do otherwise and programmed to learn and think individually

Which of the following tasks should be accomplished while preparing to write the body of an email?


Take a picture with of text messages with a camera and file it away


Back-up text messages from your phone to an email account


Send a copy of the text message to another phone


Write a copy of all the text messages you would like to save

Answers

Answer:

Write a copy of all the text messages you would like to save

The task that should be accomplished while preparing to write the body of an email is:

D. Write a copy of all the text messages you would like to save.

Activities involved while preparing to write body of an email

Preparing to write the body of an email involves organizing and gathering the necessary information to include in the email.

In this context, writing a copy of all the text messages that you would like to save is the most relevant task to accomplish before composing the email. This task ensures that you have the content you want to reference or include in the email readily available and helps you structure the email effectively.

The other tasks listed are not directly related to the email writing process and can be done separately at other times for different purposes.

Learn more about writing email at

https://brainly.com/question/24688558

#SPJ2

what's the function of a cyclebin​

Answers

Answer:

In Windows, the Recycle Bin is a folder or directory where deleted items are temporarily stored. Deleted files are not permanently removed from the hard drive but are sent instead to the Recycle Bin, unless they are too large.

Define basic logical gates with its symbol, algebraic expression and truth table.​

Answers

Answer:

A truth table is a good way to show the function of a logic gate. It shows the output states for every possible combination of input states. The symbols 0 (false) and 1 (true) are usually used in truth tables. The example truth table shows the inputs and output of an AND gate.

Explanation:

What is the most helpful way to adopt the practice of design thinking, regardless of which framework is your favorite?

Answers

Answer:

Defining, framing and solving problems from users' perspectives

Explanation:

Stretching, walking, and meditation because stretching allows everything to be loosened or not as firm walking is part of everyday life and meditation is sitting in a calm comfortable position typically with calm music as well to clear your mind.

Why these are considered as very complex?

These are all very complex because they require strength in your body and some people can't do these. Some have bad kneens so lunges can seriously hurt them others have weak arms so they can't push or hold their body wait for long periods of time and squats are difficult to do in the correct position because we can't typically do that without an actual chair

My most favorite are jumping jacks and meditation. Jumping jacks because it gets your adrenaline pumping and meditation because you can only hold so much in your mind before you get tired out. My least favorite are squats and planks. Squats are very difficult to do because you are litteraly sitting down with your back straight and the same dip of a chair but without it actually there do it's very complex.

Therefore, Stretching, walking, and meditation because stretching allows everything to be loosened or not as firm walking is part of everyday life and meditation

Learn more about Stretching on:

https://brainly.com/question/1171877

#SPJ2

Write a method that accepts an integer argument and returns the sum of all the integers from 1 up to (and including) the number passed as an argument. For example, if 3 is passed as an argument, the method will return the sum of 1+2+3, which is 6. Use recursion to calculate the sum. Test your method in main by prompting the user to enter a positive integer to sum up to. Provide input validation so that only positive values are accepted.

Answers

Answer:

mark me brainlist

Explanation:

import java.util.*;

public class Main {

       public static int sumOfNumbers(int n)

       {

               if(n==0) return 0;

               else

               return n+sumOfNumbers(n-1);

       }

       public static void main(String[] args) {

               Scanner sc=new Scanner(System.in);

               int n;

               while(true)

               {

                       System.out.println("Enter a number :");

                       n=sc.nextInt();

                       if(n<=0)

                       System.out.println("Enter a positive number ");

                       else

                       break;

               }

               System.out.println("Sum of all numbers upto "+n+" is :"+sumOfNumbers(n));

       }

}

Assign avg_owls with the average owls per zoo. Print avg_owls as an integer.

Sample output for inputs: 1 2 4
Average owls per zoo: 2

Answers

Answer:

I'm going to add a python program for this example, step by step:

We declare 4 variables for our zoo, zoo quantity, and the average.

We make the operation for the average where sum the zoo and divide with the quantity

In the last step, we print the variable avg_owls.

num_owls_zoo1 = 1

num_owls_zoo2 = 2

num_owls_zoo3 = 3

num_owls_zoo4 = 4

zoos = 4

avg_owls = 0.0

avg_owls=(num_owls_zoo1+num_owls_zoo2+num_owls_zoo3+num_owls_zoo4)/zoos

print('Average owls per zoo:', int(avg_owls))

Explanation:

The coding of the print avg_owls as an integer is written above.

What is coding?

We connect with computers through coding, often known as computer programming. Coding is similar to writing a set of instructions because it instructs a machine on what to do. You can instruct computers what to do or how to behave much more quickly by learning to write code.

We make the operation for the average, where sum the zoo and divide by the quantity.

In the last step, we print the variable avg_owls.

num_owls_zoo1 = 1

num_owls_zoo2 = 2

num_owls_zoo3 = 3

num_owls_zoo4 = 4

zoos = 4

avg_owls = 0.0

avg_owls=(num_owls_zoo1+num_owls_zoo2+num_owls_zoo3+num_owls_zoo4)/zoos

print('Average owls per zoo:', int(avg_owls))

Therefore, the coding is written above.

To learn more about coding, visit here:

https://brainly.com/question/1603398

#SPJ2

please helps me I'm really bad at this class!!!!!! 10 points

the drop down menus the same for both


web developer

web designer

design director

Answers

Answer:

Martha can apply as Web developer

Dave can apply as Design director

What two terms are used for the methods that are used to observe or modify the state of an object, respectively

Answers

The answer is: accessors and mutators

Accessors and Mutators are used to observe or modify the state of an object respectively.

The two terms used for the method that is used to observe or modify the state of an object, are accessors, and mutators.

What are accessors, and mutators?

Arrangements and mutators are both used in Java to find and set the value of private fields, respectively. Accessors and algoritmo are both referred to as getters and setters, respectively.

The verb "access," which enables the user to access the secret data in a class, serves as the inspiration for the name of the accessor function.

Accessors are the same as "winners," the "get" operation, and other similar terms. The private constants and variables are retrieved by the getters so that they can be used outside of a class.

To learn more about accessors and mutators,

https://brainly.com/question/13098886

#SPJ12

which of the following is an input device
1.speaker
2.projector
3.touch screen
4.non of the above

Answers

Answer:

non of the above

Explanation:

i am not sure but i hope it will help

Answer:

none of the above is the answer

Predicting and controlling the social impact of technology, both anticipating new technologies and their social and environment implications and the consequences of ever- increasing scale of application of older technologies is one form of contribution of:


Select one:
A. Science to technology
B. Invention to innovation
C. Innovation to invention
D. Technology to science

Answers

Answer:

This report is a response to General Assembly resolution 72/242, in which the

Commission on Science and Technology for Development is requested, through the

Economic and Social Council, to give due consideration to the impact of key rapid

technological changes on the achievement of the Sustainable Development Goals. The report

contains analysis of the impact of rapid technological change on sustainable development,

especially the consequences for the 2030 Agenda for Sustainable Development’s central

principle of “leaving no one behind”. It presents the opportunities offered by rapid

technological change regarding the achievement and monitoring of the Sustainable

Development Goals across the various economic, social and environmental dimensions.

It discusses the transformative and disruptive potential of rapid technological changes,

including economic, social and normative considerations. In the report, it is highlighted that,

without appropriate science, technology and innovation policies, technologies, be they old

or new, are unlikely to deliver progress regarding global development. Such progress

requires an environment that nurtures learning and innovation to build and manage effective

innovation systems. In this context, the report presents examples of national strategies and

policies for rapid technological change and takes stock of regional, international and multistakeholder cooperation. In addition to national and international policies, the report also

calls for the international community to continue to discuss how international technology

assessment and foresight, as well as consensus building on normative guidelines, can shape

the developmental potential of rapid technological change. It concludes with suggestions for

Member States and the international community.

Explanation:

Mei is working from home and speaking with her department manager on a Voice over IP (VoIP) phone connection. This technology allows telephone conversations to be routed over the Internet. During a VoIP conversation, Mei loses a few moments of what the manager has said to her. What is the problem

Answers

Session Layer consists that controls dialogues (interconnection) among machines in the ISO open platforms (OSI) model.

It sets up, manages, and stops the local and distant application interactions. It generates communication channels between devices, called sessions.Therefore, every OSI model Session Layer having dropped momentarily its line of communication because the information is deleted due to the magnets which drop the sessions.

Learn more:

brainly.com/question/14255125

write the working of dot matrix printer?

no links

Answers

The working of dot matrix printer is provided in the picture.

What is the correct clases for this drugs

‏Compazine
heelp me please

Answers

Answer:

making sense of medication classification

Explanation:

i think helping

which of the following not a compulsory part of a computer​

Answers

Answer:

Hardware and software are the mandatory parts

anyway keyword mouse monitor are not hardware parts of computer

AP CSA help needed. Java please.

A child’s parents promised to give the child $10 on her twelfth birthday and double the gift on every subsequent birthday until the gift exceeded $1000. Write a Java program to determine how old the girl will be when the last amount is given, and the total amount she received including the last gift.

Thank you!

Answers

#include using namespace std;int main(){int year = 12,value = 10,total = 0;do{year++;value *= 2;total += value;}while(value*2 < 1000);cout << "Age: " << year << endl;cout << "Last gift: " << value << endl;cout << "Total: " << total << endl;cin.get();return 0;

explain how to open an excel document​

Answers

Answer:

Open Microsoft

and see and in computer

PLEASE HELP ME!

Question 1. Mr. Beaver has four friends. They live in different houses. Each day he sets off from
home to visit one friend. When Mr. Beaver reaches a fork in the road he follows the arrow but, as
he passes, turns the arrow so that it now faces in the opposite direction. He always ignores the
arrows when retuming home.
On the first day he visits friend W. On day 2 he visits friend Y because he switched two arrows
around the day before. Etc.


2a) Which friend does Mr. Beaver visit on day 206? Explain your answer.
to come up with your answer

2b) Which aspect(s) of computational thinking were used

Answers

Answer:

2a) friend Y

2b) modulo calculations, state machines

Explanation:

After 4 days, history repeats itself. If you work out the first few days of the visiting pattern, you find that day 5 is identical to day 1.

So, if you divide the day number by 4 and take the remainder (i.e., the modulus), you get the original day number (where day 0 == day 4).

206 modulo 4 is 2, i.e., the second day where friend Y is visited.

The system behaves like a state machine with only 4 states.

Other Questions
Write an equation of the circle (6, -3) and radius 12. This is my answer: (x-6)^2 + (y+3)^2= 144 Is my answer correct? ^ means exponent Which of these best suggests the physical characteristics ofsound?a braking cara passing trainripples on a pondpipes through a tunnel paragraph on agriculture in bahrain What is the density of water (in g/mL) to fouf significant figures at 6C? I need help on this question please help Eggs are classified by weight. If an extra-large egg weighs 2 1/4 ounces, what is the weight of a dozen extra-large eggs A wombat runs south in a straight line with an average velocity of 5 m/s for 4minutes and then with an average velocity of 4 m/s for 3 minutes in the samedirection.What is the wombats total displacement? What is the average velocity during that time? The normal blood glucose level is between 70 mg/dL and 130 mg/dL. Write a compound inequality to represent the values at which blood glucose is not normal. i s tuyn tnh sinh vin Where does the wise person place his or her faith.science or the Bible? Someone please explain (in simple words) what subjectivity of morality means. How much money came into the cash account this month Trivia Question: What Famous Music Composer Had the First name, Wolfgang? three factors of population distribution Consider the following expression What type of number is 80i? PassageLibraries are places where people read, study, and use the computer. They need quiet. If a person stampshis feet while walking, he will bother those people trying to concentrate.QuestionIn the passage above, what does "stamps" mean?O Mails a letterO Wears socksO Steps noisilyO Makes a mark with ink An old poem reads: As I was going to Saint Ives, I met a man with seven wives. Each swife had seven kids. Each kid had seven cats. Each cat had seven kittens. Kittens, cats, kids, wives, how many were going to Saint Ives? Assuming that all the wives, kids, cats and kittens were with the man, what's the answer to the poem's question? The formula s = sqrt 30fd relates the speed S in miles per hour a car was traveling to the length d in feet that the car skidded when brakes were applied. The variable f is the coefficient of friction, which varies depending on the road surface and the condition of the tires. Which set of numbers contains the value of S for f = 0.5 and d = 63?* sqrt = Square RootSelect one:a.whole numbersb.irrational numbersc.integersd.rational numbers please answer my question it's urgent