#group by and having clause in oracle

[digitaldetoxworld]

Structured Query Language (SQL): A Comprehensive Guide

 Structured Query Language, popularly called SQL (reported "ess-que-ell" or sometimes "sequel"), is the same old language used for managing and manipulating relational databases. Developed in the early 1970s by using IBM researchers Donald D. Chamberlin and Raymond F. Boyce, SQL has when you consider that end up the dominant language for database structures round the world.

Structured query language commands with examples

Today, certainly every important relational database control system (RDBMS)—such as MySQL, PostgreSQL, Oracle, SQL Server, and SQLite—uses SQL as its core question language.

What is SQL?

SQL is a website-specific language used to:

Retrieve facts from a database.

Insert, replace, and delete statistics.

Create and modify database structures (tables, indexes, perspectives).

Manage get entry to permissions and security.

Perform data analytics and reporting.

In easy phrases, SQL permits customers to speak with databases to shop and retrieve structured information.

Key Characteristics of SQL

Declarative Language: SQL focuses on what to do, now not the way to do it. For instance, whilst you write SELECT * FROM users, you don’t need to inform SQL the way to fetch the facts—it figures that out.

Standardized: SQL has been standardized through agencies like ANSI and ISO, with maximum database structures enforcing the core language and including their very own extensions.

Relational Model-Based: SQL is designed to work with tables (also called members of the family) in which records is organized in rows and columns.

Core Components of SQL

SQL may be damaged down into numerous predominant categories of instructions, each with unique functions.

1. Data Definition Language (DDL)

DDL commands are used to outline or modify the shape of database gadgets like tables, schemas, indexes, and so forth.

Common DDL commands:

CREATE: To create a brand new table or database.

ALTER:     To modify an present table (add or put off columns).

DROP: To delete a table or database.

TRUNCATE: To delete all rows from a table but preserve its shape.

Example:

sq.

Copy

Edit

CREATE TABLE personnel (

  id INT PRIMARY KEY,

  call VARCHAR(one hundred),

  income DECIMAL(10,2)

);

2. Data Manipulation Language (DML)

DML commands are used for statistics operations which include inserting, updating, or deleting information.

Common DML commands:

SELECT: Retrieve data from one or more tables.

INSERT: Add new records.

UPDATE: Modify existing statistics.

DELETE: Remove information.

Example:

square

Copy

Edit

INSERT INTO employees (id, name, earnings)

VALUES (1, 'Alice Johnson', 75000.00);

three. Data Query Language (DQL)

Some specialists separate SELECT from DML and treat it as its very own category: DQL.

Example:

square

Copy

Edit

SELECT name, income FROM personnel WHERE profits > 60000;

This command retrieves names and salaries of employees earning more than 60,000.

4. Data Control Language (DCL)

DCL instructions cope with permissions and access manage.

Common DCL instructions:

GRANT: Give get right of entry to to users.

REVOKE: Remove access.

Example:

square

Copy

Edit

GRANT SELECT, INSERT ON personnel TO john_doe;

five. Transaction Control Language (TCL)

TCL commands manage transactions to ensure data integrity.

Common TCL instructions:

BEGIN: Start a transaction.

COMMIT: Save changes.

ROLLBACK: Undo changes.

SAVEPOINT: Set a savepoint inside a transaction.

Example:

square

Copy

Edit

BEGIN;

UPDATE personnel SET earnings = income * 1.10;

COMMIT;

SQL Clauses and Syntax Elements

WHERE: Filters rows.

ORDER BY: Sorts effects.

GROUP BY: Groups rows sharing a assets.

HAVING: Filters companies.

JOIN: Combines rows from  or greater tables.

Example with JOIN:

square

Copy

Edit

SELECT personnel.Name, departments.Name

FROM personnel

JOIN departments ON personnel.Dept_id = departments.Identity;

Types of Joins in SQL

INNER JOIN: Returns statistics with matching values in each tables.

LEFT JOIN: Returns all statistics from the left table, and matched statistics from the right.

RIGHT JOIN: Opposite of LEFT JOIN.

FULL JOIN: Returns all records while there is a in shape in either desk.

SELF JOIN: Joins a table to itself.

Subqueries and Nested Queries

A subquery is a query inside any other query.

Example:

sq.

Copy

Edit

SELECT name FROM employees

WHERE earnings > (SELECT AVG(earnings) FROM personnel);

This reveals employees who earn above common earnings.

Functions in SQL

SQL includes built-in features for acting calculations and formatting:

Aggregate Functions: SUM(), AVG(), COUNT(), MAX(), MIN()

String Functions: UPPER(), LOWER(), CONCAT()

Date Functions: NOW(), CURDATE(), DATEADD()

Conversion Functions: CAST(), CONVERT()

Indexes in SQL

An index is used to hurry up searches.

Example:

sq.

Copy

Edit

CREATE INDEX idx_name ON employees(call);

Indexes help improve the performance of queries concerning massive information.

Views in SQL

A view is a digital desk created through a question.

Example:

square

Copy

Edit

CREATE VIEW high_earners AS

SELECT call, salary FROM employees WHERE earnings > 80000;

Views are beneficial for:

Security (disguise positive columns)

Simplifying complex queries

Reusability

Normalization in SQL

Normalization is the system of organizing facts to reduce redundancy. It entails breaking a database into multiple related tables and defining overseas keys to link them.

1NF: No repeating groups.

2NF: No partial dependency.

3NF: No transitive dependency.

SQL in Real-World Applications

Web Development: Most web apps use SQL to manipulate customers, periods, orders, and content.

Data Analysis: SQL is extensively used in information analytics systems like Power BI, Tableau, and even Excel (thru Power Query).

Finance and Banking: SQL handles transaction logs, audit trails, and reporting systems.

Healthcare: Managing patient statistics, remedy records, and billing.

Retail: Inventory systems, sales analysis, and consumer statistics.

Government and Research: For storing and querying massive datasets.

Popular SQL Database Systems

MySQL: Open-supply and extensively used in internet apps.

PostgreSQL: Advanced capabilities and standards compliance.

Oracle DB: Commercial, especially scalable, agency-degree.

SQL Server: Microsoft’s relational database.

SQLite: Lightweight, file-based database used in cellular and desktop apps.

Limitations of SQL

SQL can be verbose and complicated for positive operations.

Not perfect for unstructured information (NoSQL databases like MongoDB are better acceptable).

Vendor-unique extensions can reduce portability.

Java Programming Language Tutorial

Dot Net Programming Language

C ++ Online Compliers 

C Language Compliers 

[icharchivist]

like i said. if you wanna suffer ill be happy to watch. but also the only thing i know about ff 15 is that one max0r video which while very funny is probably not 100% accurate to the story

now this is giving me too much power. I'll be happy (and sad) to oblige. And give you a quick overview.

and yeah i doubt that one video is a good description of it. so.

cracks fingers.

One of us is going to end up crying by the end of this. it's going to be me. but you're welcome to join me.

Final Fantasy 15 is the story of Noctis Lucis Caelum, crown prince of the kingdom of Lucis.

The Kingdom of Lucis is facing a crisis as the ever-growing Niflheim Empire is trying to expend and take the kingdom over, at the same time as a sickness called Starscrouge is slowly killing people. When the night falls, daemons come in the dark, and ever since those events have started happening, nights are growing longer in longer.

As the Empire of Niflheim is discussing peace treaty with the Kingdom, a clause is made on their contract to have Noctis marry Princess Lunafreya Nox Fleuret, who's been held captive by Niflheim for about a decade, and who has been Noctis's childhood friend and penpal. She is the Oracle, chosen by a prophecy to be the only person capable of healing the Starscrouge before the sickness takes hold.

King Regis decides to send his son to his marriage-to-be right before the peace treaty is officially signed, accompanied by his three most trusted friends - Ignis Scientia, who's been working as a royal advisor, cook, caretaker ever since they were children, Gladiolus Amicitia, who's been Noctis' bodyguard and royal trainer for a very long time, and Prompto Argentum, Noctis' school bestie who, despite having no relation to the royal family, is the only person outside of it Noctis managed to get close with.

But soon after their departure, the peace ceremony goes array- King Regis is murdered and the Kingdom of Lucis fall to the Empire, now leading a manhunt for Noctis to kill the royal lineage, and recover the Ring of Lucis, a powerful artefact carried through the family that, especially once coupled with the Magic Crystal that is the source of all magic in Lucis, can connect its wielder with the Kings of Old to access tremendous power left by the Gods.

See, there is a prophecy in the Lucis lineage that one day the One True King Of Light, chosen by the Gods, will be able to purge the world of the Starscrouge and Daemons, ending this curse at all cost. and, as you can imagine, this burden will fall on Noctis's shoulders as he goes through his new journey to awake the old gods and reunites the soul weapons of the previous Kings in order to unlock the full potential of his power.

The game mostly plays as an open world where you explore the valley with your besties. There is a lot that is very difficult to communicate that is just about how it feels like a camping simulator. You don't want to stay up at night for too long because Daemons are overleveled and bitch to kill, so you try to level up, do your missions, and enjoy your time connecting with your friends, learning more about them.

From Prompto's insecurities about his place in this journey, to Ignis's unwavering loyalty that would oversee Noctis's protection to the end, to Gladio devoting himself to being the shield even when everything starts to fall apart, you end up caring a lot for this group of misfits who are just trying to enjoy their journey knowing it might be their last.

You spend the game mostly having fun with them. Finding place to camp, new recipes for Ignis to cook, Prompto is constantly taking pictures and selfies to remember the journey by, you stop to every ponds to be sure Noctis can enjoy all of the fishing he can, you meet up with Gladio's little sister, it's really a really heartful game in ways that are very difficult to articulate.

... until shit hit the fan.

You're introduced to the real antagonist of the game, the Empire's chancelor, Ardyn Izunia, who's been pulling the strings all along, while also helping Noctis unlock the powers of the Gods.

And when finally it's time for you to go find Lunafreya for their wedding and hopefully linking the power of the Oracle to the King of Light in order to finally purge it all.....

Ardyn will brutally murder Lunafreya in front of Noctis, killing with her any possibility to stop the Starscrouge and the endless nights around the corner. The death itself is pretty heartbreaking, showcasing Noctis' very difficult time to deal with her loss, and Luna was defined by how she was willing to do everything to carry her duty to the end, so it was really sad.. but Luna was not very well written unfortunately (she appears maybe 15mins in the whole game up until this point) so i don't have as much to say about it :( it was super heartbreaking but yeah... yeah.

During this confrontation, Ignis will lose his eyes trying to protect Noctis, as Noctis was unconscious and Ignis grabbed the Ring of Lucis to ask for the powers of the Gods to protect him, and the Gods burn his eyes off. (it's so hard to properly explain but Ignis becoming blind ends up developping a lot of problems in the plot, of course, but especially in the gameplay. Like you spend the game having Ignis cook all sort of things and exitedly tell you about what he's going to cook today, and then your first campire after this incident you see the only food you can cook is some canned bean and it's just. so sudden in the way to tell you Ignis is changed for ever by it.)

Shortly afterward, Ardyn will create illusions that will push Noctis to push Prompto off from a moving train, resulting in Prompto getting kidnapped and experimented on by the Empire.

all while Gladio is losing his faith in Noctis because everyone is expecting so much from him, that they're their only hope, and yet Noctis is so lost in his grief that he doesn't focus on the bigger picture, while everyone he loves is losing everything around them.

When you finally decide to take down the Empire's HQ to get Prompto's back, is when a lot of truth starts to unravel.

You learn that Prompto is the clone of one of the highest funding members of the Empire, who was created to become one of the mindless drone enemies you fight the whole game, but has been smuggled out of the labs before he could be turned as such - only keeping a mark on his wrist reminding him of who he truly is. As much as Prompto always wanted to be Noctis' friend, he always feared that him being a clone, a failed weapon made by the enemies, would eventually disgust Noctis, and he feared all his life that Noctis would turn against him. so you can imagine the panic for Prompto when Noctis did attack him due to the illusions.

Most importantly though, you learn that Ardyn Izunia is actually Ardyn Lucis Caelum - one of the prince of Olds, the first person who was prophetized to be the King of Light. Bahamut himself, god of gods, gave him for missions to purge the Starscrouge, and Ardyn did just that, and took all of the Starscrouge in the world inside of his body, eradicating it from this world... and when he came to ask what he was supposed to do now, the Gods turned on him and left him to his fate, as he was not the one to actually serve to finish this prophecy. (if i recall correctly they legit say it wouldn't be narratively satisfying. Fuck the Gods, fuck Bahamut, all the homies hate Bahamut no matter the universe.)

Then, as the gods refused to clean him from the scrouge, his brothe, Somnus, tried to kill him before locking him into a magical prison and a magical slumber for the centuries that followed. Somnus became known as the Savior of Lucis, he took the credit for the actions of his brother, and build his kingdom on his ashes, continuing his royal line until Noctis' birth out of it.

When the Niflheim Empire started to come to power, they freed Ardyn, and figured out how to be able to use his power -- Ardyn could unlean the Starscrouge inside of him and have it spread into the world.... and we learn that people who "die" from the Starscrouge actually become Daemons, creature of the night, and the more people become Daemons, the longer the night will last.

And so Ardyn unleashed all of his power, all of his suffering, but himself has been turned into a Daemon at this point due to the sickness ravaging his body for centuries. He only feels pain, and he cannot die, for the sickness made him immortal. So while the Empire woke him up to use him, Ardyn decided instead to use the Empire to take revenge on the descendant of his brother, destroy the world he had sworn to save, and finally by the end, being killed by the True King of Light in the way the Gods will find narratively satisfying.

And finally, as our four companions are trying to escape the forteress, Noctis finds the Crystal, and with all the power he has gathered since then, and prompted by Ardyn telling him that the only way for him to know how to defeat him, Noctis approached it... and was taken in by the Crystal.

In there he met the Kings of Old who told him about the prophecy. The King of Light will pure the world of the Starscrouge and the Demons by taking out Ardyn for good.... but since Ardyn cannot die, his soul will always come back into his body, the King of Light must die as well in order to kill Ardyn's soul in the afterlife once its there.

Noctis therefore learns that by the end of his journey, the only thing that awaits is his own suicide in order to finally put Ardyn to rest.

The Crystal kept Noctis in it for about ten years. For ten years Noctis could do nothing but wait, as the Night fully took the lands over and destroyed everything. Only small camps here and there managed to survive and fight -- and his three friends have been trying to do their best for the people's survival, while being torn apart at the sudden loss of Noctis that day.

When Noctis finally returns, he can meet with his friends one last time. And tell them what awaits him.

For one last time you team up with your dearest friends, all of them having to be aware that they're walking you out so you can kill yourself to finally bring peace.

Before entering the final room to the final boss fight, Noctis turns to his friends, and ask Prompto to give him one of the pictures he took. You go through all the pictures you took as Prompto as you decide which picture Noctis will hold on in his last moments, holding on knowing they were the people who brought him on this journey to start with. In there Noctis will share his final words with them.

And finally you leave your friends behind. Finally it's time to fight Ardyn as he himself only awaits for death. Two dead men giving each other a last fight, two pawns by the prophecy made by the Gods, tool in a narrative that never saw them as humans, no matter how hard they clang to their humanity and to the people they loved.

One last final fight, finally killing Ardyn. And watching Noctis climbs on the throne of his father, and empale himself with all of the swords of the previous kings, in order to finish this fight in the afterlife.

And so the game ends. Ardyn is dead. The Starscrouge and Daemons are purged from this world. the Kingdom of Lucis can live on and see better days. And Noctis is dead as well, standing on the throne of his father.

In the last moments of the game you see him in the afterlife where he reunited with Lunafreya. He's holding the picture you picked in the previous scene. Looking over his friends one last time.

And then in case it's not enough you have the DLCs. Ardyn's DLC tell you more about how the Gods set them up for narrative satisfaction to start with. Then you have all three friends' DLC, set at points in game when you don't know what happened to them. But all of them ends with some final goodbye of some sort.

Gladio's DLC is the most underwhelming one in general so i don't really know what to say about it, and it doesn't really have a big payoff.

Prompto's show how he felt, abandonned in the snow when Noctis almost killed him. Having to wrestle with his existence as a clone, and figuring out if Noctis even wants him by his side. This DLC ends on a last conversation between Prompto and Noctis right before Noctis entered the crystal, in which Noctis tells Prompto he hopes he'll be by his side as he'll try to be a good king. Prompto promise he will be, always.

And then. Ignis' DLC. god that fucking DLC.

You really see the events in which Ignis stole the Ring to try to protect Noctis there, the event that rendered him blind. You see how much he fights out of devotion for Noctis. And you learn that when he put the ring on, the Kings of Old told him Noctis was going to die. Ignis spent his life protecting Noctis. In fact, you go through various flashback of their first meeting. Ignis has to learn that the kid he's protected his whole life, is going to die, and there's nothing he can do about it, because this is the fate that has been drawn on him.

On the first ending of the DLC, There is one last goodbye. Where Ignis wants to follow Noctis to the end and Noctis has to stop him, telling him that he wants him to live on.

(so that's the scene where i was crying so hard i ended up tripping in the stairs)

BUT THEN Ignis's DLC has an alternative ending. an ending where when Ignis hears the plans the Gods had planned for Noctis, he tells them, screw you. I'm never going to let it happen to him. I'll fight all of you if i have to and i'll save Noctis from this cruel fate you have planned.

And so in this ending, Ignis doesn't let Noctis walk into the Crystal and they work together, in an alternative way, until they can save him and put him on the throne.

and let me be clear: this ending is impossible by the game's lore. It's purely a fanservice fix-it ending, a what if, Ignis' ultimate proof of love that is enough to screw over the prophecy hundred of years in the making.

Where Ignis manages to save Noctis so Noctis can actually live on as the King he was raised to be. For ever at his side.

SO. WELL. WELL. I NEVER RECOVERED.

(and i am in fact crying as i'm writing all of this)

all of that while the main theme of the game is a Stand By Me cover by Florence + The Machine that will forever rip your heart and will leave you crying your eyes out as you finish this game, especially after the true ending, watching Noctis' die, and then hearing this fucking damn song.

Anyway i never fucking recovered from it. Like, never.

Like, even a summary doesn't do it justice. My first playthrough took me hundreds of hours. I spent hundred of hours with those kids. Enjoying their banters, seeing them protect each other, fight with one another. There's so much of their dynamic that is so deep into the gameplay, the way your companions will check on you during a fight, the moments they'll pause to have a high five, those moments of pure happiness where you know they're having fun by each other's side.

and Noctis being such a good character you really get to love and for what. And for what!!!!!!!! to get him killed by the end???? like for crying out loud. literally.

So yeah that's the speedrun of what FF15 is about. It's about tearing my heart out of my chest, that's what it is. (and others themes but you get my point)

Anyway. Yeah. Here you are. Here you know FF15's story.

and btw there was a little webseries set right before the event of the games, telling you how each of those friendships started. if you ever goot curious through reading all of this, i definitely recommend it. (the playlist is from newest to oldest though so be sure to watch on the right order)

was it worth it.

[tasmiyakrish]

Essential Data Science Cheat Sheets for Quick Reference

As a data scientist, having quick access to helpful cheat sheets can be invaluable. Cheat sheets provide concise summaries of key concepts, formulas, code snippets, and more - allowing you to refresh your memory or find information quickly without having to dig through lengthy reference materials.

If you want to advance your career at the Data Science Training in Pune, you need to take a systematic approach and join up for a course that best suits your interests and will greatly expand your learning path.

In this post, we've compiled some of the most essential data science cheat sheets that can serve as handy references for data professionals at all levels.

Python for Data Science Cheat Sheet

This comprehensive cheat sheet from DataCamp covers a wide range of Python essentials for data science, including:

Pandas data structures and functions

Matplotlib visualization tips

NumPy arrays and functions

Scikit-learn machine learning algorithms

And more

The cheat sheet is available in both one-page and two-page versions, making it easy to print out and keep nearby.

SQL Cheat Sheet

Mastering SQL is a crucial skill for many data roles. This SQL cheat sheet from KDnuggets provides a handy reference for common SQL statements, clauses, functions, and data types. It also includes syntax examples for popular SQL dialects like MySQL, PostgreSQL, and Oracle.

Probability and Statistics Cheat Sheet

Data science heavily relies on probability and statistics concepts. This cheat sheet from Stanford covers key formulas, distributions, and statistical tests that data scientists should know, like:

Bayes' Theorem

Central Limit Theorem

Confidence intervals

Hypothesis testing

Machine Learning Algorithms Cheat Sheet

Understanding the different machine learning algorithms and when to apply them is critical. This machine learning cheat sheet from Stanford ML Group summarizes the characteristics, use cases, and pros/cons of popular ML algorithms like linear regression, decision trees, k-nearest neighbors, and more.

For those looking to excel in Data Science, Data Science Online Training is highly suggested. Look for classes that align with your preferred programming language and learning approach.

Data Cleaning Cheat Sheet

Data cleaning and preparation is a major part of any data scientist's work. This data cleaning cheat sheet from Springboard covers common data cleaning techniques and best practices, including handling missing values, removing duplicates, handling outliers, and transforming data.

Tableau Cheat Sheet

For data visualization practitioners, this Tableau cheat sheet from The Data School provides a handy reference for Tableau functions, chart types, keyboard shortcuts, and other useful tips.

Having these essential data science cheat sheets on hand can help you work more efficiently, refresh your knowledge quickly, and become a more well-rounded data professional. Bookmark them, print them out, or keep them easily accessible as you tackle your next data science project.

[polyhedralmice]

I just signed up for the Shit or Get Off the Pot game jam on itch.io that challenges participants to design and publish 10 1-page solo ttrpgs in the month of May. I’ve already got a list of random ideas going for when the jam starts on May 1st. The (growing at an alarming rate) list includes:

- playing as the Angel AND the Devil on someone’s shoulder

- Mapmaking?

- Yahtzee style dice pool

- Playing cards/tarot cards

- A non d6 or d20 game

- Weird west?

- Travel based

- Field journal

- Radio/radio station themed? Cassettes? Mixtapes? (Use Spotify playlist? Supply Spotify playlist?)

- All the oracles

- Fate hack

- Superhero insurance agent

- Build a drum solo/guitar solo

- Dice stacking mechanic (d6s) (dice pool, when you fail you lose the die from the pool when it gets stacked. A game of inevitable failure.

- Build a Frankenstein-y monster

- Word association

- Choose your own adventure/flow chart

- Alexa keeps getting weirder (misinterpreting requests etc) Eldritch Alexa (Cthulhu?)

- Something that involves coloring shit in

- Word bank- connect the dots (words) to tell a story (include a bunch of versions for replayability )

- One-up (having to build upon the last turn with something bigger and better until there’s just utter chaos)

- Gardening (pollinators?) (set collecting) (do something/take an action, this lets you roll, you’re trying to compete something-a garden maybe?)

- Rock paper scissors combat

- Dungeon maze (play phase 1 as the lich who’s laying out all the traps and shit and play phase 2 as an adventurer trying to get the prize in the center. Phase 2 on a timer maybe?)

- You’re a villain in an Agatha Christie style murder story- plan your crime (motive, means, opportunity, victim, red herring, the twist, etc).

- A pirate burying treasure

- You play each member of a group of people trying to operate a mecha

- Roll and write

https://itch.io/jam/shit-or-get-off-the-pot

[brigitaindia]

Getting Started with My SQL DBMS

MySQL is a widely used database management system that's been developed and published by Oracle. It's a powerful, multi-user, multi-threaded platform that can handle a variety of mission-critical tasks. It's based on SQL, which is a standard language for creating database objects like tables and views, as well as building queries to access data from those objects. Here's how to get started with MySQL.

Installing and Starting MySQL

MerrySQLit can be installed on a variety of operating systems, ranging from Windows to macOS and Oracle Solaris. Additionally, it is compatible with a variety of Linux distributions, including Ubuntu, Debian and Fedora. The process of installing MySQL on Windows will vary depending on the type of operating system and the preferences of the user. The most straightforward approach is to use the MySQL Installer tool, which provides a step-by-step guide to setting up and installing a MySQL instance on Windows.

Some Basic Operations with MySQL

Logical operators are used in MySQL to join multiple conditions within a WHERE clause in order to filter data in a table. The three logical operators used in MySQL are AND (and), OR (or), and NOT (not). AND returns a record only when both the conditions are true, whereas OR (or) returns a record when at least one condition is true. NOT (not) negates the condition. Logical operators are commonly used in conjunction with comparison operators, such as =, >, and LIKE, to construct conditions.

There are three logical operators in MySQL: AND, OR, and NOT. 

AND Operator (&&): The AND operator is a logical operator in MySQL that can be used to filter data in a table by using a WHERE clause. The AND operator returns true only if all the conditions in the WHERE clause are true. For example, if any condition in the WHERE clause is false, then the AND operator returns true.

OR Operator (|| or OR): The OR operator is a logical operator in MySQL that enables data to be filtered from a table when two or more conditions are combined in a WHERE statement. The OR operator returns true when at least one condition in the WHERE statement is met.

NOT Operator (! or NOT): The NOT operator is a logical operator in MySQL that allows you to NOT condition in a WHERE clause in order to filter the data in a table. The NOT operator returns only the records that have a condition that is TRUE in a WHERE clause.

Operator Precedence

Operator precedence in MySQL is the order in which logical operators are evaluated in an SQL query. It is important to understand operator precedence when constructing complex SQL queries to ensure that the result is accurate. Matter uses a series of rules to determine the order in which to evaluate operators in MySQL. These rules are based on the type and associativity of the operator. For example, multiplication and division are evaluated from the left to the right, while addition and subtraction are evaluated from the right. Understanding operator precedence in MySQL will help you to perform your SQL queries in the correct order and ensure that the results you get are correct.

Using Parentheses for Clarity

The use of parentheses in MySQL queries allows for the grouping of conditions and the construction of more complex logical expressions, which can improve query readability and readability. This is especially useful when there are multiple conditions in a query. Parenthesis can help to avoid confusion regarding the logic of the query by grouping the conditions with parentheses and evaluating them in the desired order. In summary, the use of parentheses in queries in MySQL can make them simpler to understand, easier to maintain, and easier to troubleshoot.

Combining Operators

Logical operators can be used to combine multiple queries in MySQL to generate more complex and precise conditions that can be used to access or modify data in a database. This can help to reduce the amount of queries that need to be executed, thus saving both time and data. Additionally, the use of logical operators can enable the creation of queries that are more dynamic and adaptive, able to adjust to changes in data and conditions within the database. For example, if a table has multiple conditions, the logical operators can be combined in a query to only retrieve the required data.

Wrap Up

Once you are familiar with the installation of MySQL and the use of the MySQL Workbench tool, you can begin to explore the various features available, create various types of Database Objects, and begin constructing SQL Queries. MySQL is an adaptable database system that is suitable for a broad range of tasks. As you gain a better understanding of how it operates, you will be able to make the most of its features. MySQL Installer is designed to facilitate the installation of relational databases, and the Workbench tool makes it simple to interface with the environment and interact with the MySQL database and data. By building on this foundation, Brigita software development services can assist you in becoming more proficient in the creation of Databases and Queries, thus enabling you to better support your Data-Driven Applications.

[datarebecca]

Introduction to SQL

Introduction to SQL

One of the key concepts involved in data management is the programming language SQL (Structured Query Language). This language is widely known and used for database management by many individuals and companies around the world. SQL is used to perform creation, retrieval, updating, and deletion (CRUD) tasks on databases, making it very easy to store and query data. SQL was developed in the 1970’s by Raymond Boyce and Donald Chamberlin. It was initially created for use within IBM’s database management system but has since been developed further and become available to the public. Oracle has released an open-source system called MySQL where individuals in the public can write their own SQL to perform queries, which is a great place to start!

Types of Commands

There are three types of commands in SQL:

Data Definition Language (DDL)- DDL defines a database through create, drop, and alter table commands, as well as establishing keys (primary, foreign, etc.)

Data Control Language (DCL)- DCL controls who has access to the data.

Data Manipulation Language (DML)- DML commands are used to query a database.

Steps to Create a Table

The first step to creating a table is making a plan of what variables will be in the table as well as the type of variable. Once a plan is in place, the CREATE TABLE command is used and the variables are listed with their type and length. Then, one must identify which attributes will allow null values and which columns should be unique. At the end, all primary and foreign keys need to be identified. INSERT INTO commands are then used to fill the empty table with rows of data. If a table need to be edited, the ALTER TABLE command can be used. If it needs to be deleted, then DROP TABLE can be used to do so. Sometimes it is helpful to drop a table at the beginning of a session in case there has already been a table created with the table name one is trying to use.

SQL Query Hierarchy

Querying data is essentially asking it a question or asking it for a specified output. Nearly all DML queries begin with the same commands. First, one must identify which columns they would like to the output to contain. This is established by listing the column names after SELECT with commas in between. Aggregate function may be used in this part as well, such as SUM or COUNT. However, if an aggregate function is used, a GROUP BY must also be used (expanded upon later). Next, one must identify the table from which these columns are coming from. To do this, the table name is written after the clause FROM, and an alias may be used if multiple tables are being joined, or just to stay organized. This is also the location where one would identify any tables that are being joined, as well as the column on which they are being joined. SELECT and FROM are the two commands necessary to query data. If there are any filters one would like to use on the data that do not require an aggregation, the WHERE clause comes next. This is where the filter can be applied to the data. If aggregate functions were used in the SELECT command, a GROUP BY command would be used after WHERE. One or more columns can be used in a GROUP BY to group the data by a field (or multiple). Next, a HAVING clause is used to filter data if the filter is based on an aggregate, such as AVG. If one wants the query returned in a sorted manner, the ORDER BY command can be used to sort it in ascending or descending order. If one wants the order to be descending, DESC must be written after ORDER BY. Finally, LIMIT can be used to the limit the number of rows of data returned. These are the steps one would take when writing a query, however, the clauses are processed in a different order by the computer. The order in which they are processed by the computer is as follows: FROM, WHERE, GROUP BY, HAVING, SELECT, ORDER BY, LIMIT. It is also important to note that all these commands are used to query data, so the tables must already be created to perform these operations.

Is it Worth Learning SQL?

The short answer is- absolutely! SQL is a very commonly used programming language across the world; it is universal. Also, it is subjectively easy to learn, especially compared to coding. It is incredibly powerful when dealing with databases. The steps provided above are only for simple queries, though they are very useful. Much more advanced queries are possible with SQL, such as nested queries. If you want to get started with SQL, Data Camp offers excellent beginner courses as well as other online platforms. Because Oracle’s MySQL is open-source and easy to use, it is a great place to practice.

[krishna337]

SQL GROUP BY

The SQL GROUP BY clause is used in conjunction with the SELECT statement to organize the same data into groups. This GROUP BY clause follows the WHERE clause in the SELECT statement. Syntax SELECT columnname(s) FROM tablename WHERE condition GROUP BY columnname(s) ORDER BY columnname(s);   Example Let’s take a example table…

[doomsdayrising-rp]

2025. The state of the world is bleak. The hero teams of yesterday have been forced into early retirement by the Magistrate, a paramilitary group that has slowly sunk their claws into the United Nations and taken over. Vigilantism is outlawed, period. No exceptions, no wiggle room or gray areas, no forgiveness. No masks, not at all, not allowed. Those that dare continue to act struggle to maintain some sense of balance, with the more public-facing Justice League and Avengers forced into hiding with the ‘shoot on sight, bring in dead or alive’ clause that has recently been enacted, and the villains of today are taking full advantage. The struggle is unlike anything the hero teams could have ever predicted, and they find their hands are quite literally tied in a way they never could have seen coming.

2045. The state of the world is worse. The world has been ravaged by the Anti-Life Equation, and there is no longer much hope of any future at all. More than half of the population was overtaken by the first blast of the Anti-Life Equation, and despite technological advances to block the tech portion of the techno-organic virus, the infected are spreading the virus like wildfire with the Earth fully overtaken by the flames. One solution is left: flee the Earth, leave their home planet behind with what is remaining of humanity seeking refuge on another planet…with the hope that the Anti-Life Equation will continue to ravage the Earth and not spread upwards, outwards, looking to claim life behind the Earth’s atmosphere. And with the fear that it will.

Two Young Avengers manage the….very unlikely, the improbable. Not quite the impossible, but they might claim such for the clout. Morgan Stark (armed with her father’s stolen suit and filled to the brim with Tony Stark’s genius, audaciousness and so much moxie) blasts herself into the past after years of trying, has escaped the dark and gloomy reality of 2045, having put her father’s theories and physics to the test and finally found success. Billy Kaplan launches himself into the year of 2025, serving as Prince Consort of the Kree-Skrull Alliance with concerns for not just Earth but the universe and space as a whole. Both come to the year 2025 separately, but with the same warning: with the Magistrate takeover and the world’s heroes having gone underground, the Anti-Life Equation returns to haunt them and will take over.

The dregs of the Justice League meet at the Watchtower - a risky move, though the only way to meet without drawing the eyes of the Magistrate. The Flash, with the use of his cosmic treadmill, is able to confirm the horrors that have been brought to their attention regarding the future: in 2045, the Earth is lost and humanity is fleeing the planet in a desperate attempt at survival. Left with few other options, the Justice League extends an invitation to the remnants of the other super teams to their Watchtower to assemble a game plan.

The meeting goes poorly.

The Avengers and the Justice League are still at odds, fingers pointed in both directions and slewing blame back and forth. The Titans, the primary forward-facing hero team, are exhausted and out of resources. The Birds of Prey take some of their load, though operate more quietly, more covertly, to stay off of the Magistrate’s radar. There is only one solution, though none are happy to come to the same consensus: the Justice League and the Avengers must come out of retirement, bear some of the load in the fight against the Magistrate, and they must work together. Multiple teams must become one to stand any chance against the Magistrate, and they are working against the clock to prevent a very real disaster that is looming overhead.

Divide and conquer. The X-Men have primarily taken to Genosha, which remains free of the Magistrate’s hands and influence, and agree to look into formulating a potential vaccine against the virus that will ransack their planet. Oracle with the Birds of Prey will tackle the technological portion of the virus and look for preventative measures.  The Avengers and the Justice League will come out of retirement, re-join the fight, and work against the Magistrate and work to destroy the paramilitary’s hold on the UN.

The Hall of Justice has been abandoned for nearly two years, and the Avengers Tower soon followed. Titans Tower was forcibly taken from the Titans within the last few months. This leaves…the Watchtower as the only safe space for the heroes to confer and work. And there is uproar. Sharing resources and people and conferring together as a team is one matter. Sharing space that has long since belonged to the Justice League is another. The Avengers blame the Justice League for their poor handling of Darkseid in the first place, and the Justice League blame the Avengers for Tony Stark’s snap bringing the Anti-Life Equation back into their reality. Despite too-hot tempers, bitter ends and beyond sour grapes it is agreed: the Watchtower will become the new base for all super teams, effective immediately. Agreement does not mean acceptance. The warring reinstated super teams may be sharing space, but they are far from sharing the opinion of enjoying it. The other individuals and super teams are left to serve as a buffer…if they don’t already have opinions leaning one way or the other regarding the civil war on the Watchtower that may only add fuel to the fire.

[starclick30]

50 Sql Inquiry Questions You Need To Exercise For Interview

You can pick distinct documents from a table by utilizing the UNIQUE keyword phrase. Trigger in SQL is are a unique type of stored procedures that are specified to implement automatically in place or after information adjustments. It enables you to carry out a batch of code when an insert, update or any other question is executed against a particular table. DROP command eliminates a table and also it can not be rolled back from the database whereas TRUNCATE command eliminates all the rows from the table. This index does not allow the area to have duplicate values if the column is special indexed. Longevity indicates that when a transaction has been dedicated, it will certainly remain so, even in the event of power loss, crashes, or errors. In a relational database, for instance, once a group of SQL statements implement, the outcomes require to be kept completely. The SELECT statement is made use of as a partial DML statement, utilized to select all or relevant documents in the table. Denormalization is made use of to access the information from greater or reduced regular form of database. It likewise processes redundancy right into a table by including information from the associated tables. Denormalization includes required repetitive term right into the tables so that we can stay clear of making use of complicated joins as well as many other complex operations. t mean that normalization will not be done, however the denormalization process takes place after the normalization procedure. Think of a solitary column in a table that is inhabited with either a solitary number (0-9) or a single character (a-z, A-Z). Write a SQL inquiry to publish 'Fizz' for a numeric worth or 'Buzz' for alphabetical value for all values because column. Finally utilize the DEALLOCATE declaration to delete the cursor meaning and also release the associated sources. Clustering index can boost the performance of many query operations since they supply a linear-access path to data saved in the database. DeNormalization is a method used to access the information from higher to decrease regular types of database. It is also procedure of introducing redundancy into a table by including information from the related tables. Normalization is the process of reducing redundancy and also dependence by organizing fields and table of a database. The major objective of Normalization is to add, erase or modify field that can be made in a single table. APrimary keyis a column or a set of columns that uniquely identifies each row in the table. The information kept in the database can be customized, obtained and also deleted as well as can be of any type of type like strings, numbers, photos and so on. A CTE or common table expression is an expression which includes short-term outcome set which is defined in a SQL declaration. By utilizing DISTINCT key words duplicating records in a query can be avoided. When stored in a database, varchar2 uses just the allocated space. E.g. if you have a varchar2 and placed 50 bytes in the table, it will use 52 bytes. Stored Procedure is a feature includes many SQL statement to access the data source system. Numerous SQL statements are settled into a kept treatment and also implement them whenever and wherever called for. SQL represents Structured Query Language is a domain name particular programs language for managing the information in Database Administration Solution. SQL programs skills are extremely desirable and needed out there, as there is a huge use Database Management Systems in practically every software program application. To get a work, prospects require to crack the interview in which they are asked various SQL interview questions. A Stored Treatment is a function which includes numerous SQL declarations to access the data source system. Numerous SQL statements are settled into a kept treatment and also execute them whenever and also wherever required which saves time and prevent writing code time and again. If a main key is defined, a one-of-a-kind index can be applied immediately. An index refers to a performance adjusting method of enabling much faster access of records from the table. An index creates an access for every value as well as therefore it will be faster to retrieve data. Denormalization refers to a strategy which is utilized to gain access to information from higher to lower kinds of a data source. It aids the data source supervisors to raise the efficiency of the entire infrastructure as it introduces redundancy into a table. It adds the redundant information into a table by incorporating database questions that incorporate information from numerous tables into a solitary table. A DB question is a code written in order to obtain the details back from the data source. Question can be made as if it matched with our expectation of the result collection. Unique index can be applied immediately when main key is specified. An index is performance tuning approach of allowing much faster retrieval of records from the table. An index creates an entrance for each and every worth as well as it will certainly be much faster to get data. To defend against power loss, transactions need to be recorded in a non-volatile memory. Compose a inquiry to bring values in table test_a that are as well as not in test_b without utilizing the NOT keyword phrase. A self SIGN UP WITH is a case of normal join where a table is signed up with to itself based upon some relation between its very own column. Self-join makes use of the INNER JOIN or LEFT JOIN clause as well as a table pen name is made use of to designate various names to the table within the query. In this guide you will certainly locate a collection of real world SQL meeting inquiries asked in firms like Google, Oracle, Amazon.com and also Microsoft and so on. Each question includes a completely composed solution inline, saving your interview prep work time. TRUNCATE removes all the rows from the table, as well as it can not be rolled back. An Index is an unique structure related to a table speed up the efficiency of questions. https://geekinterview.net Index can be created on several columns of a table. A table can have just one PRIMARY KEY whereas there can be any variety of UNIQUE secrets. Main key can not contain Void values whereas One-of-a-kind key can have Void worths. MINUS - returns all unique rows selected by the first query but not by the second. UNION - returns all unique rows selected by either query UNION ALL - returns all rows chosen by either query, consisting of all duplicates. DECLINE command removes a table from the database and also procedure can not be curtailed. MINUS operator is utilized to return rows from the initial inquiry however not from the 2nd question. Matching records of first as well as 2nd query as well as various other rows from the very first question will be presented therefore set. Cross sign up with specifies as Cartesian product where variety of rows in the first table increased by number of rows in the 2nd table. If suppose, WHERE clause is made use of in cross sign up with then the inquiry will function like an INNER SIGN UP WITH. A nonclustered index does not alter the method it was kept yet develops a full separate item within the table. It point back to the original table rows after looking.

Considering the data source schema showed in the SQLServer-style diagram below, write a SQL inquiry to return a checklist of all the invoices. For every invoice, show the Billing ID, the billing day, the customer's name, as well as the name of the client that referred that customer. PROCLAIM a arrow after any type of variable declaration. The cursor statement must always be associated with a SELECT Declaration. The OPEN statement have to be called before fetching rows from the result set. FETCH statement to get and also relocate to the next row in the result set. Call the CLOSE declaration to shut off the arrow.

[brieflyprofoundsandwich]

The Way to Locate Sql Technical Interview Questions Online Make certain you understand every question. If you put in the interview room backed by a few years of DBMS Administration experience you're going to be asked questions in your own real life encounter. Evidently, questions vary greatly because of position you are recruiting for. Below you will find some general questions to find more information regarding candidate's SQL abilities. It's a simple fact that the questions may be answered in many of ways that are potential. Almost invariably, if you're a fresher, you're likely to be asked issues, or else you are a Database Administrator. You should answer some questions concerning SSRS, to start in the company. https://tinyurl.com/y2emjnh4 Continue reading and you'll find an answer. The answer should be one. The issue is you need to express the solution in your words in order for your abilities and imagination will come out at front of the interviewers. What Does Sql Technical Interview Questions Mean? When we encounter a problem the first thing we must do would be to realize the matter. The issue is the SQL Standard asserts that we can't elect for a column which is not part of the group by clause unless it contained inside an aggregate function. https://annuaire-du-net.com/sql-interview-questions-and-answers/ The issue here is that we do not know what will be returned because we're not with what we are requesting in the SQL specific enough! As soon as you've known what the matter is, another thing to do is to write down the issue in words and also the sources of input. Brush up as much as you are able to, if your expertise is a bit mild. My experience is that I get a fantastic deal more if I've finished a legwork that is tiny to begin with to what's being taught, to find some exposure. Knowledge gained through conference sessions is a source of expertise that is high quality, but direct experience is always the best thing. What the corporation will need from you would be to be able to utilize that knowledge to mine the information pertinent to your analysis from the database, although an comprehension of SQL commands is outstanding. First you want the database abilities and then you require the meeting abilities. The skills for the database might be obtained on the job. You might be asked to spell out the reasons you left the occupation. Jobs may be implemented on demand. So If you're looking for work that is connected to SSIS, you have to prepare yourself for the 2019 SSIS interview queries. PSRELEASE you might have observed there are lesser skilled folks, who manage to find the tasks easily and you wind up in the receiving end. Interviews are an excellent way to assess abilities . You dress up 16, if you are going for an in person interview afterward ensure. Interviews contain a couple of concerns. An interview enables the candidate to estimate needs of the job and the corporate culture. For those professionals which are looking forward to attending Oracle Database Administrator interview in times, below are a few. Your interviewer is trying to observe the way your character will contribute to a positive, open work culture. The interviewer would love to know you discover that it's possible when things are not straightforward to be resourceful and flexible. She or he wants to know what you are searching for which you did not find in your prior occupation. She or he wishes to know that you're capable of handling situations, and that you can resolve problems yourself. Your interviewer will probably need to look at your knowledge to find out whether you will name the orders required for programmers. Coding evaluations may be used in two ways. In order to display accurate, they need to be the ones that are ideal. Online coding tests are sometimes a procedure. annuaire-du-net sql developer interview questions There are some SQL tests available on the market but often they verify the academic knowledge instead of abilities and programming skills of candidate to deal with real life difficulties. http://bit.ly/2jYDMm8 Things You Won't Like About Sql Technical Interview Questions and Matters You Will Information can be stored only in 1 order on disc. Data control language (DCL) is a sort of syntax that's comparable to a computer programming language. There are and it is determined by the association between tables.

[quintessence-sentimentalist]

Caleb, Peter, the Oracle/Himerish and Yan Lin for the ask game.

Alright, after a VERY unexpected hiatus (for which I wholeheartedly apologize), I’m finally back with responses to the ask game I reblogged with the expectation of answering much sooner.

Answers below the cut, with the exception of favorite photo (I just didn’t have the time to search through both comics and cartoon to find the best ones).

Caleb

• favorite thing about them: 

I guess the fact that he pulls off Badass Normal pretty well, surrounded by all of these powerful women. He can still hold his own in a fight, and managed to coordinate a successful rebellion in a world long under tyrannical rule. Also, can’t forget the literal dream-guy aspect of his initial comics characterization.

• least favorite thing about them: 

On the animated series side, I really dislike the toxic masculinity and sexism fueling his characterization, which was especially prominent in season 1 (and thankfully waned as the series went on). Which I guess is also my problem with him in the comics, except that trait came out of the blue well into his time in the series and served the sole purpose of breaking up his relationship.

• favorite line: 

I do like the first romantic scene between Caleb and Cornelia, so I’ll go with his speech there. 

• brOTP: 

Listen, “D is for Dangerous” is one of my favorite episodes of the animated series, so Caleb and Matt is always a favorite relationship. He also has a fun relationship with the girls in season 1 (when he’s not being all “Ugh, girls”), and I do like his comic partnership with Vathek.

• OTP:

I don’t really ship them actively, but Cornelia and Caleb have a fun dynamic in the animated series, and the initial concept of them in the comics is really sweet.

• nOTP:

I’m not a fan of Elyon/Caleb for a number of reasons, and with the way CxC ended in the comics, I just don’t see there being a good way for them to get back together later on, so I really don’t ship Caleb with anyone after about issue #20. 

• random headcanon: 

Well, my knee-jerk reaction here is that cartoon-verse Caleb would find one unusual—by his peer group and personal characterization’s standards—hobby and be amazing at it and honestly enjoy it. Like in “Divide and Conquer” we got natural snowboarder Caleb because the sport had a Meridian counterpart, for a hot second he played a guitar on the school roof, and then “D is for Dangerous” was rife with his inability to understand Earth teenager things. So based on all of that, I’m thinking he’d somehow latch onto some activity that’s quiet and leisurely—because the guy needs it, he’s basically been raised in and for battle since conception—but still involves some skill and concentration. Something that can help him take his mind off things but also be productive, allowing him to create something fun and useful.

Basically, this is my roundabout way of saying that I had the mental image of Caleb taking up knitting and being great at it, maybe making the girls shawls and scarves for Guardian business in colder climates (because Kandrakar knows that the uniforms don’t offer optimal coverage). There’s just something comforting about the repetition to stitching, where he can either tune out to everything or focus on something else while his hands still work the needles without interruption. It makes even war rooms for the latest universal threat less of a stressor for him, and oh no I think I’m attached to this concept that started as a stray thought based on one of my own hobbies.

• unpopular opinion: 

Mm, maybe just the fact that he’s not my favorite love interest in either media, even when on his best behavior? In terms of ship-related stuff, I most frequently see CxC as the popular canon pairing, and while I’m glad to see the love for them (means that this series overall is getting the love it deserves!), I’m personally just neutral and can’t really muster up any strong feelings. I pretty sure that’s just a ME thing, because many a time I’ve just been chill with major canon pairings, not really caring either way, while I’ll positively be clutching my heart and wanting to cry over my tiny canoe of a minor or even wildly non-canon pairing. So I’m totally down with and supportive of Caleb/CxC fans, even if I don’t feel what they do as potently.

• song i associate with them:

I feel like I use this song for every “enduring fight against evil” situation, but I’m still going to go with “The Good Guys” by the Elms (and of course, I can’t find a YouTube link for it…). I just feel like it captures the weariness of leading a rebellion against an oppressive superpower—especially in the days before the Guardians’ involvement—and the fact that Caleb is just a guy fighting without any powers. “When all you got is a single shot/You do the best job that you can/’Cause it’s a long road for a simple man.”

Peter

• favorite thing about them:

Look, he’s just a really great guy all-around. Best older brother, caring boyfriend, good friend, and the coolest dude who’s simultaneously a complete dork.

• least favorite thing about them:

I’m just going to go with the fact that he really doesn’t have any character in his short time in the animated series except to be a) Taranee’s brother (without really seeing anything with their relationship) and b) Caleb’s short-lived romantic foil for Cornelia.

• favorite line:

Not so much a line as a particular scene that sticks in my head as an iconic Peter moment, and it’s just this one comic image of him balancing on a kitchen chair like it’s a surfboard, excited that Taranee got accepted for the Redstone exchange program because it’s a “surfer’s paradise.” Like he’s super proud of his little sister for her achievements, but he’s also very much a surfer dude dork who’s going to geek out over some choice waves and get yelled at by his mom for standing on the furniture.

• brOTP:

He is the BEST big brother to Taranee, so of course that has to be my top choice.

• OTP:

Peter/Cornelia deserve so much more love than what I’ve given them in the past, they’re precious.

• nOTP:

I don’t really have one, at least not a specific one? PxC is the only thing I know in terms of Peter shipping.

• random headcanon:

In the instance where he finds out about the Guardians, I imagine he’d be like the Team Mom (or Best Boyfriend, in Cornelia’s case). Much like his sister, he’s not going to be pleased with the Council and what they put the Guardians through—really, if you throw Judge Cook in here too the three of them would probably put the entire establishment on trial and win. But in the meantime, until definitive change can be made, Peter devotes his time to making sure the girls are taken care of and maintaining a proper balance between their two lives. He’s probably there with cookies and hot chocolate and fuzzy blankets after every rough mission, letting the Guardians finish the initial debrief before ushering them to a mandatory movie night or something to decompress. Date nights with Cornelia invoke a firm no-Guardian-business clause, where all conversation is on everything but and any lingering concerns are checked at the door, where they can remain for a few hours.

It’s just… this is Peter’s sister and girlfriend and their best friends, and it’s in his nature to be a very chill, caring dude. If pre-New Power Matt was ecstatic about providing support by running interference while the girls are away on mission, then I imagine Peter would be the go-to guy for emotional support after a battle.

• unpopular opinion: 

Mmm, just as a stray thought, I guess I’d have liked to see more of him in the animated series? Not sure if that’d be unpopular, but given the fact that CxC have something of a better relationship there than in the comics and Peter was pretty much introduced into that canon for the sole purpose of a love triangle, I thought it might be. So yeah, I’d have liked to see cartoon Peter some more—give me the good brotherly moments with Taranee, and I’d be curious to see a platonic friendship with Cornelia (and maybe even Caleb) assuming endgame CxC.

• song i associate with them: 

Because I’m such a cheeseball, we’re going with an era-appropriate selection in “Catch Your Wave” by the Click Five, a song I still unabashedly love nearly 15 years later (and consider criminally underrated compared to the popularity of “Just the Girl”). Chosen partly because of the ‘00s feel and partly because Peter is a surfer, and frankly I think he’d be enough of a cheeseball to sing this one for Cornelia.

The Oracle/Himerish

• favorite thing about them: 

I do enjoy that the “Trial of the Oracle” arc humanized him a bit. I feel like it’s not often that you get to see such a higher-power character be brought down a bit and not only reveal their more normal past, but have them return to it for a time. It was an interesting change of perspective, both as a reader and for Himerish himself. 

• least favorite thing about them: 

Probably everything related to the “these are young teenagers fighting your battles and enduring what will almost certainly be lasting psychological trauma (given the prior generation, where, FYI, one of them killed another and you just kind of locked her away and let two of the distraught survivors be banned from your sky fortress for eternity because they dared question your judgement in expression of their trauma from losing two best friends to this madness), and you’re still going with this, huh, Himerish?” situation. We’re not going to delve into that any more because we will be here for a while.

• favorite line: 

Oh, I can’t remember which arc it’s from (the end of Book of Elements, maybe?), but there’s this one sequence where Himerish and Yan Lin are simultaneously (yet separately) getting ready for a celebration and having a bit of fun with it, and Himerish jokingly looks at his reflection and says, “Maybe I’ll get a haircut!” I’m just laughing thinking about it, so we’re going with it.

• brOTP: 

I mean, Himerish and Tibor (and Yan Lin) is the ultimate Kandrakar BROTP. Himerish also had a much more human relationship with the Guardians and Orube with the fourth arc, which I appreciated.

• OTP: 

Uh, frankly not something I’ve thought of for him, so we’re going to pass.

• nOTP: 

Again, not something I’ve considered, but I guess I’d say Oracle ships with the Guardians are not my thing? 

• random headcanon: 

Oh, he definitely kept that outfit with the baseball hat and the Cupid t-shirt. Both Tibor and Endarno almost had an aneurysm the first time he wore it to a Council meeting.

• unpopular opinion: 

Ehn, well I guess I’ll go with the fact that even after Trial of the Oracle he’s still not one of my favorites. The arc definitely humanized him, a fact for which I’m grateful, but I’m still not huge into Kandrakar overall.

• song i associate with them: 

You know, for someone who massively associates songs with characters and/or stories, this one was a really tough one. But I was trawling my music library and stumbled on Rascal Flatts’s “I’m Movin’ On” and it just slammed into me.

Now I know I largely don’t recognize the arcs post-Ragorlang, partially because I don’t know them well (having only read them once) and partially because what I do remember was bad, but I still have this lingering image of Himerish’s final page in the series, where he just quietly walks away and disappears from Kandrakar. I don’t remember the context of this in the slightest—like I can’t remember if it was his choice to leave (unlike during Trial of the Oracle) or if he was being called into question again—but I do just remember this silent sendoff, and seeing this song made me think of this scene. From the title alone, it’s very much a bittersweet goodbye kind of song and I’ve loved it for that purpose, which I think it serves perfectly here. Particularly the line “I never dreamed home would end up where I don’t belong”—for so long, Himerish had been synonymous with the position of Oracle and Kandrakar itself, yet as Trial of the Oracle showed us, he led a very different life prior to taking the title. The fact that he’s leaving (presumably by choice, because that’s the way my memory is leaning at the moment) just reads to me as him no longer feeling like he fits within the infinity of Kandrakar—the place that once encompassed the whole of his being—and knowing that it’s time to be moving on.

Yan Lin

• favorite thing about them: 

She’s just the ultimate grandma. So very sweet and supportive to her granddaughter and her friends, and always the one to dispense wisdom. Also, she’s one of the few characters—if not the only—where I honestly can’t decide if I love her comic or animated counterpart more. They’re very different characters—comics Yan Lin is traditionally wise and kindhearted, while cartoon Yannie is the kind that will teach you an important lesson and then make some sort of witty comment and/or break out her old tennis racket that she found in the attic—but still so great.

• least favorite thing about them:

Hmm, maybe just how she had to watch one friend go power-mad, another get murdered by the first, and two get exiled forever from Kandrakar for saying this isn’t right, and yet she has no apparent fears or concerns about her granddaughter serving as a Guardian and running the same risks, amongst others? I get that Yan Lin would be proud at the very beginning because by the time the Nerissa arc happens everything was well out of the creators’ hands and thus nothing could be foreshadowed, but you’d still think that there’d be some level of terror once Nerissa awakens. 

• favorite line: 

Just because it’s in my head, I’m going with the aforementioned tennis racket bit from the cartoon. After she gives Hay Lin the map and Hay Lin questions if it’s because they’ve matured enough in their powers to handle the burden: “Nah, it was in the attic. I couldn’t find it. Found my old tennis racket too. [swings racket] FORE!!!”

• brOTP: 

Honestly, I love Yan Lin as the honorary grandma for all of the girls. I’ll also say BROTP to C.h.y.k.n. (pre-everything awful, obviously), and Caleb and Yan Lin’s cartoon relationship, especially in season 1, is pretty fun too.

• OTP: 

Well the animated series paired Yan Lin (or at least her Altermere) with Zacharias Lyndon, so I guess I’ll go with that. 

• nOTP: 

Don’t really have anything specific in mind?

• random headcanon: 

Not really a headcanon, but I have to wonder what younger Yan Lin—particularly the animated one—was like with her (presumed) late husband. I mean, the woman was a literal force of nature in her youth and is uniquely wise in her prime, so what was the love story between her and Grandpa Lin? Was it more of an opposites-attract sort of thing—solid bedrock to her whirlwind—or was it more like-to-like?

Given Chen’s overprotectiveness in the animated series, my thought is he was the rational child of two eccentric spirits.

• unpopular opinion: 

Granted, I don’t remember these arcs well at all to judge the execution, so this is based more on the concept: I’m not super into the Oracle Yan Lin idea. Not as a testament to her ability to do the job or anything, but it just doesn’t work for me with her character. While she’s had apparent faith in the Council and Himerish all along—even after Nerissa’s betrayal and Cassidy’s murder, the breaking point for both Kadma and Halinor—Yan Lin will always put her granddaughter’s safety first and foremost, as much as she can given the dangers of Guardianship. She’s gone out of her way and behind the Council’s back to get crucial messages to Hay Lin, and even smuggled the key to the Crown of Light to Will while Elyon was being held prisoner under Phobos-as-Endarno’s—AKA the new Oracle—rule. For as much as she outwardly believes in the laws of Kandrakar and the power of the Oracle, Yan Lin is not afraid to quietly go rogue and do what she knows is right.

That last point could arguably be a positive to Oracle Yan Lin—Kandrakar knows that plenty of modifications could be made to Kandrakar’s policies (i.e. the dangers of Guardianship)—except for the fact that Yan Lin’s stealth aid almost always comes as a last-minute, dire situation save. It’s not a preemptive way to diffuse the situation (which you’d think she’d want to do, given how maybe both Nerissa and Cassidy could have been saved if the Council had intervened sooner and with a better plan) when she comes to Hay Lin with the analogy about the oak and the rush, but a survival tip for when Will attacks the girls. Similarly, Yan Lin only gets the fragment of Elyon’s power to Will when she knows Phobos is hot on her tail and will take her out of the picture in mere moments. The fact that she only interferes when desperate times call could speak to her trust in the girls to handle things on their own, but it doesn’t bode as well for future change to the burdens of Guardianship that she could viably make as Oracle. Plus, the fact that her granddaughter is a serving Guardian almost certainly clouds Yan Lin’s actions—would she take similar actions even if it wasn’t Hay Lin’s life on the line?

And we’re going to stop there because that’s getting into different territory than I intended, but the short of it is I’m not into the concept of Oracle Yan Lin and much prefer her as the devoted Council member who’ll still sneak behind the laws of Kandrakar to protect her girls.

• song i associate with them: 

First thing that came to mind was “Cassiopeia” by Sara Bareilles. Normally I’d say this is more of a Hay Lin song, just in terms of the star imagery and whimsical sound, but what sold me is the first line: “Come in close now, it’s time to tell a story.” And isn’t that the epitome of Yan Lin’s character! The revelation of the girls’ Guardianship, the Four Dragons—all of them start as stories that Yan Lin tells. So I guess it could still work as a Hay Lin song too, just within the frame of it as a story told by her grandmother.

[jq37]

sooo.... what’s the tea on the new ep? :)

**spoilers for family in flames**

I have so much to say I’m not drafting this on tumblr lest it crash and I lose a soul-crushing amount of yelling into the void.

And, I gotta say, THIS episode is the reason I haven’t posted my adult rankings list yet. THIS RIGHT HERE. I KNEW some crap was gonna go down and force me to make some HUGE adjustments.

Also, We are feeling vindicated in this house today! But let’s start from the top and work our way down.

“Raise your hands if you really care about your parents.”

Fabian having to be like, “Look, your parents suck but don’t you have siblings?” (Kristen: Ugh, I guess)

Adaine pointing out that she cares about Gorgug’s parents.

Brennan listening to them argue about what to do like he doesn’t know they’re about to be arrested for a whole ass MONTH.

Fig wanting to method act while texting the phone, pretending to be scared.

So is the arcade owner (Frank Dunford) relevant? Brennan had the name on hand. But maybe it was just him being a good worldbuilder and anticipating the question. I feel like it’s probably that because this is late in the game to be introducing new people who are super relevant.

“Gilear’s got a little knife”

I KNEW those arcade prizes were gonna be gear they could pick up! ALWAYS RAID THE ROOM. Some of that stuff might have helped in the fight. I loved the group silently reading the cards and exchanging them to whoever they thought it would help most in the background as Brennan did the ID spell.

“This has been, if I may say so, the *best* use of the identify spell.”

I love that Adaine thanks everyone, including her inanimate spells. She’s just a good person.

OK so this episode addressed a LOT of questions I had about how these literal children were getting away with all of these murders and such. Apparently, the adventuring academy kids traditionally just get away with this stuff because of Arthur’s influence and the nature of adventurers.

Adaine coming in hot with the diplomatic immunity and then remembering, oh wait, we’re at war w/ Falinel.

Fig immediately starting smoking when she gets arrested.

I love the federal agent outsider with perspective coming in and being rightfully horrified by the absolute nonsense that’s been going on the past 15 episodes.

Is Riz’s mom the only competent cop at this station? Is there a one competent adult per location rule?

Bill Seacaster Upon Learning the Bad Kids are In Jail: Did you try to escape?

“How are things going?”/“I mean bad. I’m in jail.”

Fig upon offhandedly and indirectly being called a vigilante by Sklonda: Thank you.

Emily loses it whenever anything happens in Gilear’s orbit.

Wild that Adaine decided to spontaneously call Goldenhoard considering what happened later. Like, it wasn’t a completely out of nowhere decision and it was totally logical but they could have easily overlooked that decision. 

Like, I know things happen later that make this kinda moot but I loved Goldenhoard’s conversation with Adaine in jail. “Don’t to talk to anyone without a lawyer and kill anyone you have to to get out. The school will pay for the rezzes.”/“That’s exactly what our plan was. God, I love this school.”

Although, sidenote, I feel like you can only easily rez someone within a minute? Like, I know there are other D&D spells that let you do it after a longer period of time but with the whole phoenix egg thing and the fact that they haven’t come up so far, I feel like Brennan isn’t using the in this setting for stakes reasons.

Man that whole conversation with Fig and her mom. Emily plays Fig so balls to the wall that I kinda forget sometimes that she’s actually an intelligent adult woman who knows what she’s doing with the character so I really shouldn’t be surprised with how well she stuck the emotional beats of this episode.

Gorthalax man! TyraWeWereAllRootingForYou.gif If he left, like, actually left and isn’t just held up somehow, then that’s gonna be really not great for Fig’s general psyche. 

Kristen COMPLETELY undercutting the moment by point blank asking if they had sex.

No wonder Sandra-Lynn was so worried about Fig. She was totally Fig growing up. Which, lol, she’s not even half tiefling. She was just *like that*

Oh so Gilear has always been super lame. Good to know.

Fig: I think I have mommy issues./The Rest of the Party: You have all the issues.

Fabian: You’re trying to hook up with a 25 year old adult./Fig: What do you mean trying?I’m successfully kissing him once every couple weeks. (Which, lol but also I’m glad that’s as far as it got…you know if it has to go any amount forward).

They just let Bill into the cell?????

Lou when Zac rolls a 1 for perception on Bill Secaster and he knows what’s coming: Don’t fucking do this. (Everyone else: Already trying not to lose it)

Zac’s Gorgug being contemplative and also completely wrong face is so funny to me every time.

“Why would you kill me?”/“Why would you know that?”

Who is more insane? Gorgug for suggesting him and Fabian could be twins (aren’t they different ages????) or Bill for thinking he’s so awesome he could somehow do that?

Kristen trying to help FIg distract Bill by blurting out, “Have you ever had sex?” After the conversation where he said point blank he’s slept with 100s of orc women. 

Fabian yelling at his dad is kinda undercut by continuing to call him papa in the most poncy accent.

I don’t think I’ve articulated this properly before but this episode really drove it home: Fabian and Bill have a *close* relationship but not an entirely healthy one. Like, better than Adaine and her parents by leaps and bounds but he wrestled his son in a jail cell while his friends just watched. Like, who does that?

Imagine if Riz had tried to get between Bill and Fabian. 

Also imagine being the rest of the party just sitting there, watching that go down.

“We’ve spent so much of our lives obsessed with our dads and we’ve completely ignored our moms.”/“You’re just again talking about yourself.”

I can’t believe Fig’s suggestion spell would have worked if head boss in charge fed lady hadn’t been there. Speaking of her, as soon as she showed up I knew they weren’t going to be able to shenanigan their way out of this one (which is literally the word Emily used, hilariously). I don’t think even a nat 20 would have gotten them very far. Remember last week when I said that I was sure there was going to be a prom finale but I was also pretty sure there was still a good chunk of time before prom? As soon as they got arrested and the feds showed up I was like, “Oh they are not getting out until prom for sure.”

Siobhan trying not to laugh while Emily tries a ridiculous plan that might have worked in a different episode honestly.

Ally trying to Pirates of the Carribean her way out of the jail cell.

The cops didn’t even take their stuff in a month!

“I’m glad this is in my head and no one else can hear things like this.”

I love how Fabian rolls his eyes at Adaine for thanking her spells but he always thanks the Hangman.

Realistically the Hangman would have told Fabian the plan before it happened but the way it played out was soooo good.

The return of Mr. Cubby!!!! I was hoping it would be him but man! It was still so awesome to see happen. I wonder if Brennan introduced that family specifically in case the group ever needed to be busted out of jail (a likely need).

“Laws are threats made by the dominant socioeconomic ethnic group of a given nation.”

“You guys wanna make some bacon?”

“That was on fire the whole time? You’re so brave!” Adaine likes adults who aren’t her parents so much.

Riz being like uhhhhh my mom works here.

“To the AV club!”/“It’s been months!”

OK so they took a palimpsest from Bill in this episode. That was there to tip them off that he’s up to something I’m sure, but I feel like that could also turn out to be a Chekov’s gun for next ep. I’m sure the ability to trap someone’s should would be useful in the finale.

S/O to Brennan for his excellent foreshadowing throughout the episode and honestly the whole series.

Siobhan thinking to check the trash folder of his computer was a good move, even if it didn’t end up being the right one.

OK, strap in guys. This is where things get WILD.

Siobhan’s “Oh shit!” when she got halfway down the page of Watches and Wards and then that Harry Potter sounding sting in the background.

(Before I get any further, I love that Adaine’s first thought was well that means my sister isn’t Kal Vaxis because she thinks her sister is the root of all evil).

But WOW. After all the trash talking of the old oracle, it turns out Adaine is the new eleven oracle! And she has been since EPISODE ONE. I almost thought she was gonna be *that* elven oracle because of the questions the cast was asking but nope. It is, as Zac and Siobhan put it, a The Santa Clause situation where the last one dies and someone else gets the job.

Brennan’s faint amusement as they work through that is so good.

You know what’s kinda hilarious in hindsight about that? I said before that, so far, every person Adaine has pegged as trash has ended up being trash of the highest order and an enemy of the party and of course she’s been good at predicting things! She’s the literal oracle.

Am I reading this wrong or is the Religious Studies teacher name Yolanda Badgood?

Also the sheet says “Lunchlad (Official Title)” RIP dude.

Emily low key thinking this is going to be about pay disparity between the races.

Will putting the book back retroactively get rid of anything bad currently cast in school?

Brennan going, “Nothing happens.”/“You see an upside down waste paper basket.” Is such a GM mood. I had a session once where I spent half an hour just saying, “You’re looking at the door,” in various ways.

No one knows what Goldenhoard’s name actually is and it’s the second to last episode.

I feel like Brennan must have gotten forehead/cheek kissed a lot as a child because he’s constantly having NPCs do it. 

Are elves in this setting actually immortal (barring being actually killed) or just long lived? Because Adaine talks like she’s immortal but I wasn’t sure. Anyway, newsflash Adaine. You’ve been mortal this whole campaign! Because apparently, the elven oracle always eventually dies. 

I love that Adaine finally confronted the oracle about sinking on a ship and actually ended up kinda sympathizing with her. I can’t believe this is how that running joke ends.

Fabian at the ghost of the past eleven oracle who’s imparting wisdom on Adaine: Who are you?

Ally: Can I do something weird? (Dude, when do you not?)

Ally mumbling through an inspiring spell as Murph clues in to the paperwork discrepancy that blows the plot twist wide open. And then miming the whole thing in the background as the scene goes on.

“He was mean so I thought that meant he was a good guy.” More stern than mean really but yeah! Same Murph!

You know how you know things are about to get real? When the DM starts letting you do stuff like bust down doors without even rolling for it because there are bigger fish to fry.

The 69 glyphs of binding. Nice.

But in seriousness, Kal Vaxis (apparently it’s spelled Kalvaxus but I can’t be bothered to change that in this post) was apparently trapped by Arthur and bound to work at Aguefort (as Goldenhoard) because…he’s a wildcard I guess. Sidenote, can you imagine what this season might have looked like if Arthur hadn’t died? Or was that always the plan for him to die in some way? Like to resurrect an NPC maybe if the crew hadn’t lost 2 party members.

Man when he said last ep that the girls were going back to school I thought OK that makes sense because it’s the AV computer that Biz used or maybe it’s Penelope. But I totally overlooked teachers.

OK so the binding spell specifically says “as long as I live” and Arthur is dead. So….what does that mean exactly? And this plan seems to have been in motion from before Arthur died. What does that mean? Also, if that wording means he’s freed when Arthur dies, what was Arthur thinking killing himself???? Did he need Kristen to sneak him into heaven so he could talk to Sol and do some scheming or something? AHHHHH I have so many questions.

Also in the binding is a clause about tea. Now, first of all, Arthur, bro. Come on. Second of all, a lawyer really should have looked at that. “I will drink anything you give me”? I work at a law firm. I’m a lowly first year but even I know that’s a terrible thing to put in a contract. I’m sure y'all non lawyers know that too!

Karam-Kajam (the binding spell words) kinda looks like “magic maker” backwards. That doesn’t mean anything. I just wanted y'all to know I was freeze framing every thing that might be a clue.

OK ok ok, so I’ve been saying for a while now (in posts but mainly over chat) that all this bad stuff must be like connected to a central person in service of a central goal but the players were probably all unconnected wild cards acting in self interest. The one thing I couldn’t quite put together was what because these plots have been mainly unconnected. But now, we have it! All the weird things starting a war (by manipulating the harvestmen), getting 7 maidens (by manipulating Biz), and reinstating prom king/queen (by manipulating (?) Penelope and Dayne, also yes! my wild card guess was that prom king/queen was going to be part of a spell or curse or something. Guess it was prophecy but yes! vindication!) are parts of a prophecy on how to bring back Kalvaxis! (Along with him getting his “glittering treasure”?)

But yeah! No wonder it was so hard to put the pieces together! They all connected but only through a prophecy. Good job Bren!

“The sun shall fall from the heavens” is part of the prophecy which makes me think Sol or Helios might be involved in this somehow.

Ally: There are definitely going to be 7 virgins at prom. (That deserved a rim shot).

Good on Murph for making sure none of them were on the virgin list bc that would have been a pain in the ass to find out mid-fight. Also, I KNEW “Where are their bodies” was the question to ask last ep when Biz said they were going back to their bodies.

“Who told you that? An oracle?”

I hope Adaine just uses her oracle status to make sick one liners like, “I predict this is gonna hurt,” before she witchbolts someone. She never does her actual job. 

Adaine who hates her family, righteously indignant: Between our houses and the world, you expect us to choose our houses?

The rest of the group who loves their family: BYEEEEE.

Well, no. Kristen also had reservations before she remembered her brothers existed.

Adaine texting her mom: You should probably leave.

Siobahn and Ally fistbumping over their mutual not caring about their parents.

OK so what’s up with the rat? What’s so important about the rat? And what’s up with Zayne? We still haven’t figured out what’s up with him.

Still not clear on if the crystals trap your physical body or just your spirit and leave your physical body dormant irl.

So that’s how they got rid of the adults for the fight. Nice job again Brennan.

As far as I can tell, Brennan made up this usage of the word palimpsest and I’d never heard of the word before and now I type it so much. Wild.

“I’m calling an Uber. You use the minute to go look at as much shit as you can. Jump in the Uber with me, come to my house. Look Rudolpho will be here in two minutes in a Honda Civic. Use one of those minutes. Go.”

A Knight to Remember. 

They freaking Chitty Chitty Bang Bang to Kristen’s house.

I love how Uber Drivers in this world are still gunning for 5 stars.

OK, time for the most stressful 30 minutes of Fantasy High (so far).

I think the wagering mechanic Brennan used for the fights was brilliant. For each conflict a d20 was rolled. 1-6=epic fail. 7-14=bad but not awful. 15-20=favorable outcome. The twist was that if the person chose to help their family they could give up half their HP and 14 spell levels and he would roll with advantage.

Everyone quickly took that deal except Adaine who truly does not give a damn about her family (and also, reasonably, thought that they wouldn’t even be at home. Idk why they apparently were tbh).

When Emily said, “She’s a complex person and she’s allowed to be,” that was the moment I was like, “Oh yeah. She’s not actually Fig. IRL she knows what’s happening.”

Siobhan uses her divination roll of 18 to save Kristen’s family without having to risk anything but the Ally turns around and decides to take the deal to try and save Adaine’s family WHEN ADAINE DOESN’T EVEN CARE. But it makes sense that Kristen would.

Lou’s monolog as Brennan rolls about how nerve wracking and terrible it is to have no idea what’s going on.

“This is the worst thing I’ve been a part of.”

“I was wondering why my mom visited me and humanized herself and this is exactly why.”

Lou/Fabian: What if my fucking family dies? (F O R E S H A D O W I N G, albeit unknowingly)

Brennan (sagely): It couldn’t have been any other way./Siobhan: It could’ve been!

lol at Adaine trying to trigger that ice cream later wish at their darkest moment (so far). Also, not that I think Brennan ever forgot about it but now I’m for sure it’s gonna come up next ep bc if nothing else that would have reminded him.

OK first up, Fig and her mom.

“Dang they’re already organized with costumes?”

That was so boss, her mom getting revived and then IMMEDIATELY shooting two guys w/ her bow.

Emily LEGIT crying through that scene. The whole room was on an emotional tightrope. You can tell.

Where in the mountains Sandra-Lynn!? I want specifics Sandra-Lynn!!

I love the idea of her jumping out of a window onto a dope griffin’s back. Fig’s mom just bought herself a bunch of spots on my grown-up rankings list.

Ally: THAT WAS NUMBER ONE

Me: SAME.

Next Riz at Strongtower

I knew Sklonda was going to be in the secret room!

I love that apparently Riz can recognize his mom’s gun by hearing it.

I know it was in the promo but Riz’s mom being like, “I was so scared you were gonna ask me to prom” was hysterical.

You just know Sklonda and Agent Angela have been fighting like cats and dogs this past month.

Riz and his mom high fiving. They have the best relationship.

Gorgug and the Thistlesprings

lol, looks like his parents had the easiest time wrecking their intruders.

But based on how it was described as compared to everyone else (bar Fabian–we’re getting there), it sounds like he got pretty dang hurt.

And I guess they have a tank (which they usually use to mow the lawn) and a bomb chest? Wild.

Anyway, if anything had happened to them insert Rosa B99 meme.

“You come to the tree, you better be ready to never fucking leave, you understand?” So boss. (Also, is that a pun?)

Gorgug’s parents launched a satellite while Gorgug was in jail.

Kristen and co.

Kristen’s dad (who is the worst): You think these guys were illegals, what?

Kristen: I’m gonna take the car, byeeee.

Kristen and Adaine bonding over their terrible parents.

I’m Concerned about Kristen’s brothers.

Abernants

They poofed out. Idk why they were still there to begin with.

So the damage they took was supposed to represent the danger the took in their respective fights. Kristen got Adaine’s divination roll meaning her family was fine either way but she did take damage for Adaine’s family. But the fight was already over by the time they got there. So, in story, any injuries sustained must have been from the fight at her house, even though that wasn’t technically the deal.

Anyway, Adaine doesn’t care about her family so let’s not waste any time moving onto

Seacaster manor

Geez

OK, you guys. Let me tell you my buildup to the realization that Bill had to die.

In the first set of episodes, when tone was established, I said to myself, a parent is going to die. I don’t know who, but someone will.

Then, Bill gave them a training montage and I thought, curse of the mentor. He’s going to die. Besides, he’s one of the biggest parental figures and he’s larger than life–perfect for a fall.

Then Sklonda took down the Harvestmen and I briefly shifted my worry to her.

But then Fabian started clashing with Bill. And I remembered all the constant talk of his mortality.

And then, this ep, Brennan made him choose between his mom and dad and I was pretty sure. (sidenote: Fabian yelling at his mom the same ep Adaine said he has a great relationship with his mom. But, like, compared to her, maybe. Also, mean Brennan.)

And then Fabian lost an eye (with a description that still makes me wince) and I KNEW. Once he lost his eye, there was no way Bill could leave the fight alive, thematically.

Honestly, it was a wrap when Fabian played the video from his dad. I was worried he’d die before he got there. 

(It was a low blow, and I credit you that.)

Why were there Harvestmen attacking Fabian’s house and no one elses?

Fabian’s mom just drinking while the house is being raided.

I was so sure the tuxed Harvestman who attacked Fabian was going to turn out to somehow be Daybreak or something. Anyway, it has to come up again. There’s no reason for that level of detail otherwise. And tux sounds like prom attire.

Lou rolls a nat 1 and then rerolls it because he has the lucky trait. What’s funny is just started listening to NADNDPod and Murph (who reminded Lou about the lucky thing) disallowed one of his players from rerolling a nat 1 even w/ the lucky in the last ep I listened to. I don’t remember if the circumstances were different though.

Bill handcuffing himself up to keep fighting. Yikes.

Anyway, ugh that whole death scene. I would write more but this is closing in on 4k words and I’ve been working on this for hours. I just wanna say, that was a perfect way to go out for him. Killing 60 people and then getting stabbed by his son and exploding. So baller (as was Fabian jumping out the window onto his bike and catching Bill’s sword. He has so many cool swords now).

It’s a crime no one does animatics for this show.

We also got a piece of the puzzle. Bill was the one supplying the palimpsests (or at least one of the ones. who was doing it before?) not for an evil reason. Just a chaotic neutral reason of wanting to recapture the glory days. So now we know that.

I mentioned this before but…Fabian is Thor.

“I SHALL LEAP INTO HELL AND KILL THE DEVIL HIMSELF” and Bill Seacaster is dril apparently.

I love Fabian destroying the nice thing Bill said about him to preserve his legacy.

Ally: HE COULD HAVE SURVIVED.

I appreciate so much that Lou knew his character so well that without any hesitation he stabbed Bill and that was the right choice.

Whew, that was a lot.

Also, not that I don’t trust Brennan but it’s wild that Bill, the most thematically appropriate parent to die, was the only one who failed his roll apparently. 

Aww at Zelda’s message to Gorgug. She made him a playlist! So 80’s high school. It gives him a bonus! Also I really wanna know what’s on the list. Like, is it all fantasy rock puns or actual songs? Yay for Brennan giving them cool items for good RPing. 

Live band. Nice.

Emily and Zac both rolled 20’s for initiative for next week’s fight. Hopefully that’s a good omen. We have no way of knowing because THERE’S NO PROMO FOR NEXT WEEK.

AHHHHHHHHHHHH

AHHHHHHHHHHHHHHHH

This isn’t edited. This is more than 4000 words. This is so long my computer is about to die. Thank you and goodnight. 

[legalbits-blog]

Is it possible to sell digital video games?

Back in 2012, the Court of Justice of the European Union (CJEU) issued its decision on UsedSoft GmbH v Oracle International Group (C-128/11). According to the judgement, download-only-software can be resold under some conditions.

So, is it legal to sell download-only video games?

Warning! This blog will only tackle digital computer games, downloaded from platforms such as Steam, Origin or UPlay.

Now, whereas computer programs fall under the Software Directive (2009/24/EC), other types of digital contents (i.e. e-books) are regulated in the Information Society Directive (2001/29/EC). This distinction is essential because:

a)     There are meaningful differences between both Directives

Arguably, the main finding of the UsedSoft case is that the doctrine of exhaustion also applies to intangible goods, this doctrine involves that “once copyright-protected work has been publicly put on the market within the European Economic Area (EEA), it can be freely resold within the EEA”. (1)

One could argue that if it is possible to sell an online copy of Microsoft Office, why wouldn’t it be possible to sell a Steam copy of Sid Meier’s Civilization V?

As mentioned, computer programs fall under a specific Directive (lex specialis), while to other digital contents apply the Information Society Directive (2001/29/EC), in which its recitals 28 and 29 and Article 3(3) note that the doctrine of exhaustion does not cover digital copies of any artwork.

b)     The ruling solely applies to the Software Directive

Even though the CJEU recognises that the concepts used in both Directives should have the same meaning, it notes that:

“[E]ven supposing that Article 4(2) of Directive 2001/29, (…), indicated that, for the works covered by that directive, the exhaustion of the distribution right concerned only tangible objects, that would not be capable of affecting the interpretation of Article 4(2) of Directive 2009/24, having regard to the different intention expressed by the European Union legislature in the specific context of that Directive”. (par. 60, C-128/11)

Consequently, it can’t be inferred from this judgement that the doctrine of exhaustion also applies to digital contents other than software. In fact, in 2014, the Landgericht Berlin ruled that the UsedSoft digital exhaustion doesn’t apply to video games. (2)

What if we consider video games as software?

We can’t. Paragraph 23 of the CJEU judgement on the case Nintendo Co. Ltd and Others v PC Box Srl and 9Net Srl (C-355/12) states that videogames can’t be deemed as computer programs.

A bright future?

Twitter: @UFCquechoisir

Recently, the UFC-Que Choisir revealed that the High Court of Paris decided that it should be possible to resell games from a Steam library, and ruled that Steam’s clause, which prohibits selling computer games is “deemed unwritten” due to its unfair and unlawful nature. (3) For further explanation: ‘Condamnation de Steam’ and video (French only). However, this ruling can be appealed, which means we will still need to wait for a definitive answer.

 Concluding, I believe Directive 2009/24 is more suitable to the current digital world than Directive 2001/29, due to its better technological understanding. It must have been difficult to foresee in 2001 the rise of platforms such as Steam, but now that they have come into play, I think it’s time to amend Directive 2001/29.

[krishna337]

SQL HAVING Clause

The HAVING clause enables you to specify the conditions that filter which group results are appear in the results. This clause applies to SQL because we cannot use the WHERE clause with the iSQL aggregate functions. Both the WHERE and HAVING clauses are used to filter records in SQL queries.   Syntax SELECT columnname(s) FROM tablename WHERE [condition] GROUP BY columnname(s) HAVING…

[troutrabbi05-blog]

The SQL Interview Questions Cover Up

There is a reason . Since, it is not possible to determine of the runtime errors during testing fo the code, the'WHEN Others' exclusion is utilized to deal with the exceptions which are managed. SQL syntax is not case sensitive. In case you've got a table and have loaded data twice it's likely to de-duplicate in lots of ways, although there aren't any constraints to ensure uniqueness or key. There table sample function. As it operates on pages not pops it is random and it may not also yield the amount. There aren't many best techniques or technical elements to learn in the industry of marketing that is email. You will learn the way to use MySQL efficiently to get your work done more . https://is.gd/kqrdm4 SQL is popular with web developers because of simplicity and its flexibility. SQL stands for Structured Query Language, and it's an extremely potent and diverse language used to make and query databases. Before you commence learning SQL, it's important to acquire a fantastic database management system to successfully practice. There are lots of many unique kinds of databases made for functions that are different and strategies. A A A A Any database should go via a normalization process to make certain that information is represented only once. It is only an organized form of data for storing simple access, retrieval and managing of data. Can consist of different views of the database. So you can begin your SQL interview preparation there you receive sample data creation the queries. It's very beneficial to analyze the main reason for slow questions that are running. An aggregate query might have a clause that is Getting. SQL Interview Questions: No Longer a Mystery The work is reversed as if it was not issued. The work achieved by the trade gets permanent. Clearly, there's a need for the possible employer to feel assured that you cannot only browse a data model but speak about alterations to that model and additionally write SQL. The answer is that you need to play with functions. The very first answer (and also the one that you want to listen ) is using foreign vital limitations. Each question should take no longer than one minute to reply. From the finish of the course you'll know the best way to answer on your interview and also precisely what kinds of questions to expect. Programming interview question may appear daunting, yet they a test to determine an applicant that is knowledgeable is. https://tinyurl.com/y2emjnh4 The matter is the SQL Standard states that we can't decide unless it contained within an function on a column that isn't part of this group by clause. The problem here is that we do not understand what will be returned because we are not with what we are asking for in the SQL particular! A number of those less-experienced developers are going to be in a position to answer it, but using a less clarity. Oracle developers utilize NVL feature, MySQL developers utilize IFNULL function and SQL Server programmers utilize function. It's very beneficial for a potential database programmer to be aware of the selections of the best way, and triggers easily available. It is a standard practice to opt for the listing of topics to be covered and ensure you have prepared yourself in each of the areas whenever you are getting ready to get a SSAS interview. Each statement begins with a distinctive keyword. As every statement isn't independently stripped off it is much more efficient. You can update one or columns in the specific moment. It is comparable to a except that there are not any grouping columns. Furthermore, the columns in each statement has to be in the exact order. Yes, row that was correct has been generated by it. A key is just one particular table that might be associated with some other table's key. https://annuaire-du-net.com/sql-interview-questions-and-answers/ http://bit.ly/2jYDMm8 Each table has its own name and is composed of rows and columns. All tables need to have clustered index. Have a peek at the dining table. Your table has for reporting purpose you'll have to show one row every 26, rows for day that is data that is legitimate yet. These tables represent a set. You'll go past a set of questions which are quite likely to be asked on a SQL Interview.

[roofchalk95-blog]

The Trick for Sql Interview Questions for Experienced Professionals

What You Need to Do to Find Out About Sql Interview Questions for Experienced Professionals Before You're Left Behind They are commands used to combine queries to be able to get outcomes. Scheduled tasks or jobs are used to automate procedures which may be conducted on a scheduled period at a standard interval. The usage of their responses given below and the questions is to guarantee that women and the men who examine them and learn them will secure a comprehension of the XML functionalities supplied by SQL Server. There's a reason for the error read on to understand why. The issue is the SQL Standard says that a column which is not part of the group by clause unless it contained inside an function can't be picked by us. The problem here is that we don't know because we are not with what we are requesting in the SQL particular 19, what will be returned! My problem is that I want to eliminate duplicates in the outcome and don't appear to be able to accomplish this. Whether there aren't any configuration problems that block the server you can start an instance of Microsoft SQL Server by utilizing the configuration startup choice. You will find the questions are not loyal to any right answer but there is always scope for improvement in your reply. It is a simple fact that the aforementioned questions might be answered in a number of other potential ways. Answers are extremely precise. The reply ought to be one. http://bit.ly/2jYDMm8 The issue is that you want to express the reply in your words and imagination will come out in front of their interviewers. Please help me to enhance the answer if you believe so. Do not say yes just to locate the job when the true answer is no. Finding Sql Interview Questions Whizlabs pioneering the internet certification training business aims that will allow you to construct a booming career. Technology is moving at a fast speed. There are several database systems out there, and individuals will be unfamiliar with the ins and out of each one of them. Functions are available in gleaning information regarding the error to aid. The SUBSTR function is utilized to return specific part of series in a string that was particular. Integrity constraints are utilised to ensure accuracy and consistency of information. Taking away the columns that are not determined by constraints that are important that are primary. You'd really like all unmatched and matched information from only one table. https://tinyurl.com/y2emjnh4 There are types of connect that are utilised to recover data and it is contingent on the connection between tables. The New Fuss About Sql Interview Questions for Professionals SQL server can be connected to any database which has OLE-DB supplier to extend a hyperlink. SQL Server from Microsoft is largely supposed to be employed on Windows Systems. Microsoft SQL Server supports varieties of XML indexes. Database is merely an form of information for accessibility, storing, retrieval and managing of information. Oracle database consists of 3 kinds of documents. https://is.gd/kqrdm4 https://annuaire-du-net.com/sql-interview-questions-and-answers/ There are three sorts of sub query 9. There you get the queries for sample data generation so that you can quickly start your SQL interview preparation. There are a great deal of data types extended in PL SQL but mostly you might be using several the ones that are well-known. Things You Should Know About Sql Interview Questions for Professionals You need to see that the assurance level before going into the office. As an applicant, you should concentrate on communicating skills and your own confidence level. It requires skill to make them see it when you're an ideal match. First you need the database abilities and you want the interview skills. The Key to Sql Interview Questions for Professionals By referencing foreign key with another table's key key relationship has to be made between two tables. Database Relationship is understood to be the relation between the tables in a database. You may understand what is SQL in DBMS's function. Thus you have to find out your candidate . Candidates will need to prepare to provide examples from past job experiences, sharing tales which enable the feasible employer to get a comprehension of skillset that is present. The candidate will be able to notify you cursors are utilized to perform processing. Interviewers are going to need to see your coding skills to check your general adaptability. The interviewers desire to feel confident you have the ideal skills, but additionally that your will be a pleasant and productive coworker. Your interviewer will probably have to look at your knowledge to see whether you will name the orders required for programmers. Employers are a lot more likely to respond well to credibility versus perfectionism. They'll want to make certain they're hiring a SQL programmer who is experienced with the set of internet technologies they use in their company, which explains why it's beneficial that you have experience with RDBMSs.