andreyuhai

How to create laravel projects

To create laravel dependent projects using composer:

composer create-project laravel/laravel your_project_name --prefer-dist

andreyuhai

How to change Apache's root directory to some other directory

You'll have to edit apache2.conf and 000-default.conf to change the document root of apache.

The Apache server is installed on var/www/html.This is the default root directory of apache.

Either change the root directory of Apache or move the project to /var/www/html.

To change Apache's root directory, run:

andreyuhai

WITH Orders (customerID, orderNum) AS
(
	SELECT CustomerID, COUNT(*) 'number of orders'
	FROM Sales.SalesOrderHeader
	GROUP BY CustomerID
)
SELECT customerID, 'Value' =
	CASE
		WHEN orderNum > (SELECT (AVG(CAST(orderNum AS FLOAT)))
						 FROM Orders

andreyuhai

select 
    cust_id,
    gender,
    weight
from customer c
WHERE weight >  (SELECT AVG(weight)  
                 FROM customer 
                 WHERE gender = c.gender)
order by c.gender

andreyuhai

/etc/default/grub GRUB_CMDLINE_LINUX_DEFAULT="quiet splash acpi_backlight=vendor"

sudo update-grub

if this does not work then try

/etc/default/grub GRUB_CMDLINE_LINUX_DEFAULT="quiet splash acpi_backlight=video"