Answer:
The answer is below
Explanation:
The the sql command to list the total sales by customer , month , and product, with subtotals by customer and by month and a grand total for all product sales is:
SELECT S.CUS_CODE, T.TM_MONTH, S.P_CODE,
SUM(S.SALE_UNITS*S.SALE_PRICE) AS "TOTSALES"
FROM DWDAYSALESFACT AS S INNER JOIN DWTIME AS T ON S.TM_ID =
T.TM_ID
GROUP BY S.CUS_CODE,T.TM_MONTH,S.P_CODE WITH ROLLUP;
Answer:
The program to this question as follows:
Program:
targetValue = 0.3333 #defining variable targetValue and assign value
sensorReading = 0.0 #defining variable sensorReading and assign value
sensorReading = 1.0/3.0 #calculate value in sensorReading variable
Val=sensorReading - targetValue
#calculate the difference and store in Val variable
if (Val < 0.0001): #use of if block to check condition
print ("Equal") #print value
else: #else block
print ("Not equal") #print value
Output:
Equal
Explanation:
In the above Python program code, there are two variables "targetValue and sensorReading" is defined, in which targetValue store a value, that is "0.3333", and sensorReading holds a value, that is "0.0".
- In the next step, the "Val" variable is defined, that calculate the difference between both variable, that conditional statement is used.
- In if block, if the value is less then "0.0001", it will print value "Equal", otherwise, it will go to the else block, that will print "Not equal".
Answer:
This article shows how to use regex to remove spaces in between a String.
A string with spaces in between.
String text = "Hello World Java.";
We want to remove the spaces and display it as below:
Hello World Java.
1. Java regex remove spaces
In Java, we can use regex \\s+ to match whitespace characters, and replaceAll("\\s+", " ") to replace them with a single space.
Regex explanation.
`\\s` # Matches whitespace characters.
+ # One or more
StringRemoveSpaces.java
package com.mkyong.regex.string;
public class StringRemoveSpaces {
public static void main(String[] args) {
String text = "Hello World Java.";
String result = text.replaceAll("\\s+", " ");
System.out.println(result);
}
}
Output
Terminal
Hello World Java.
You can find the components that you wanted to modify in : C. control panel
You can adjust your computer's setting through control panel, whether it's your system and security, hardware, net work setting, etc
hope this helps
