Laravel Complex SQL Aggregations

Perform advanced database aggregations including GROUP BY, COUNT, SUM, AVG for powerful data analysis and reporting

PHP Code Editor

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
<?php
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
use Illuminate\Support\Facades\DB;
Schema::create('users', function (Blueprint $table) {
    $table->id();
    $table->string('name');
    $table->string('email')->unique();
    $table->string('role')->default('user');
    $table->boolean('active')->default(true);
    $table->timestamps();
});
for ($i = 1; $i <= 200; $i++) {
    DB::table('users')->insert([
        'name' => 'User ' . $i,
        'email' => "user{$i}@test.com",
        'role' => ['user', 'admin', 'moderator', 'vip'][array_rand(['user', 'admin', 'moderator', 'vip'])],
        'active' => rand(0, 100) > 20, // 80% active
        'created_at' => now()->subDays(rand(0, 730)), // Last 2 years
        'updated_at' => now(),
    ]);
}
 
 
הההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההה
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

Execution Result

Ready to execute

Click the "Run Script" button to see the output here

Shared Scripts

Laravel Eloquent hasMany Example with Pagination

Learn how to use Eloquent hasMany relationship in Laravel to fetch user posts with pagination. Try it in our PHP Sandbox!

Implement a binary tree in PHP with a search function

You'll need classes for both the tree and its nodes. The search operation will allow you to find a specific value within the tree.

Laravel Complex Joins and Relationships

Laravel Tinker Complex SQL Joins - Multi-Table Queries. Execute complex JOIN operations across multiple tables

PHP Bubble Sort: Simple and Effective Sorting Algorithm

Bubble sort has a time complexity of O(n^2), making it inefficient on large lists. For larger, more efficient algorithms like Quick Sort or Merge Sort.

Laravel Complex SQL Aggregations - Group By Analytics

Perform advanced database aggregations including GROUP BY, COUNT, SUM, AVG for powerful data analysis and reporting

Laravel Complex SQL Aggregations - Group By Analytics

Perform advanced database aggregations including GROUP BY, COUNT, SUM, AVG for powerful data analysis and reporting

PHP Code Editor

Execution Result

Ready to execute

Description

Comments

Shared Scripts

Laravel Eloquent hasMany Example with Pagination

Implement a binary tree in PHP with a search function

Laravel Complex Joins and Relationships

PHP Bubble Sort: Simple and Effective Sorting Algorithm

Laravel Complex SQL Aggregations - Group By Analytics