Number questions

`String.prototype.repeat` returns a new string with the specified number of copies of the original string, concatenated together. 

const str = 'abc';
const repeated = str.repeat(3);
console.log(repeated); // 'abcabcabc'

`String.prototype.localeCompare` compares two strings in the current locale and returns a number indicating whether the calling string comes before, after, or is equal to the compared string. 

const str1 = 'apple';
const str2 = 'banana';
const result = str1.localeCompare(str2);
console.log(result); // -1 (str1 is less than str2)

The VALUE function converts text that represents a number into a numeric value. For example, =VALUE('1234') converts the text '1234' into the number 1234. This function is useful when working with text values that need to be used in numerical calculations.

The SQRT function returns the square root of a number. For example, =SQRT(16) returns 4, as 4 is the square root of 16. This function is useful for mathematical calculations involving square roots and can be used in various formulae and data analysis tasks.

The CEILING function rounds a number up to the nearest multiple of a specified value. For example, =CEILING(5.3, 1) returns 6, as it rounds 5.3 up to the nearest whole number. This function is useful for rounding numbers in financial and statistical calculations.

The FLOOR function rounds a number down to the nearest multiple of a specified value. For example, =FLOOR(5.7, 1) returns 5, as it rounds 5.7 down to the nearest whole number. This function is useful for financial and statistical calculations requiring rounding down.

The COUNTIF function counts the number of cells that meet a specific condition. For example, =COUNTIF(A1:A10, '>10') counts how many cells in the range A1:A10 contain values greater than 10. This function is useful for tallying occurrences that match a certain criterion.

The ROUND function rounds a number to a specified number of digits. For example, =ROUND(123.456, 2) rounds 123.456 to 123.46. This function is useful for controlling the precision of numerical values in calculations and financial reports.

The AUTO_INCREMENT attribute allows MySQL to automatically generate a unique integer for a column, typically used for primary keys. For example, defining a column as `user_id INT AUTO_INCREMENT PRIMARY KEY` ensures each new user record gets a unique ID without manual input.